使用文本框查看数据库中的数据 [英] View data from database using textbox
问题描述
我已经在访问数据库中设置了某种格式,但是当我尝试在文本框中查看时,它没有使用我设置的格式查看值.我将vb.net用作编程语言,将ms access用作数据库
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
访问数据库:
字段名称:sampleID 数据类型:自动编号 格式:"000000"
Field Name : sampleID Data Type : AutoNumber Format : "000000"
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()
在运行程序= 14后在文本框中输出
output in textbox after run program= 14
我要查看的实际输出是000014
the actual output that i want to view is 000014
推荐答案
这是因为从sql返回的值是整数,而不是字符串.您可以更改代码以按照自己的方式重新设置其格式:
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#")
这篇关于使用文本框查看数据库中的数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!