View data from database using textbox

Question

I have made some format in my access database,but when i try to view in textbox it not view the value using the format that i have set it. I use vb.net as a programming language and ms access as a database

Access database :

Field Name : sampleID Data Type : AutoNumber Format : "000000"

VB.net code :

sql = "SELECT * FROM Cleaning"
    cmd = New OleDbCommand(sql, cnnOLEDB)
    cnnOLEDB.Open()

    Dim dr As OleDbDataReader
    dr = cmd.ExecuteReader()
    While dr.Read()

        txtSampleID.Text = dr("sampleID").ToString()

    End While
    dr.Close()

output in textbox after run program= 14

the actual output that i want to view is 000014

Do not add formatting to tables, it is rarely a good idea as it will lead to confusion about data types. — Fionnuala
– Fionnuala, Commented Oct 31, 2012 at 10:31

Robert Beaubien · Accepted Answer · 2012-10-31 06:44:45Z

1

That's because the value being returned from sql is an integer, not a string. You can change your code to re-format it the way you want:

    txtSampleID.Text = Cint(dr("sampleID")).ToString("00000#")

answered Oct 31, 2012 at 6:44

Robert Beaubien

3,1564 gold badges24 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Fionnuala Over a year ago

@user692495 It seems that this answer has solved your problem, if this is the case, you can accept the answer. The details are in the faq stackoverflow.com/faq#howtoask

user692495 · Accepted Answer · 2012-11-01 00:37:42Z

0

sql = "SELECT * FROM Cleaning"
cmd = New OleDbCommand(sql, cnnOLEDB)
cnnOLEDB.Open()

Dim dr As OleDbDataReader
dr = cmd.ExecuteReader()
While dr.Read()

   txtSampleID.Text = Cint(dr("sampleID")).ToString("00000#")
End While
dr.Close()

answered Nov 1, 2012 at 0:37

user692495

692 gold badges6 silver badges13 bronze badges

Collectives™ on Stack Overflow

View data from database using textbox

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related