vb.net 使用文本框查看数据库中的数据
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/13152534/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
View data from database using textbox
提问by user692495
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
我在访问数据库中创建了一些格式，但是当我尝试在文本框中查看时，它没有使用我设置的格式查看值。我使用 vb.net 作为编程语言，使用 ms access 作为数据库
Access database :
访问数据库：
Field Name : sampleID Data Type : AutoNumber Format : "000000"
字段名称：sampleID 数据类型：自动编号格式：“000000”
VB.net code :
VB.net 代码：
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
运行程序后在文本框中输出= 14
the actual output that i want to view is 000014
我想查看的实际输出是 000014
回答by Robert Beaubien
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:
那是因为从 sql 返回的值是一个整数，而不是一个字符串。您可以更改代码以按照您想要的方式重新格式化：
txtSampleID.Text = Cint(dr("sampleID")).ToString("00000#")
回答by user692495
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()
