在VB.NET中将mysql数据添加到列表框中
答
我希望这段代码能帮助你了解你在找什么。
Private sub FillListBox
Dim stringConn As String
Dim stringCmd As String
Dim myConn As MySqlConnection
Dim myCmd As MySqlCommand
'Frame your query here.
stringCmd = "SELECT yourData FROM yourTable"
'Frame your connection string here.
stringConn = "SERVER=localhost;DATABASE=DBName;UID=root;PASSWORD=;"
'Get your connection here.
myConn = New MySqlConnection(stringConn)
'Get a command by using your connection and query.
myCmd = New MySqlCommand(stringCmd, myConn)
'Open the connection.
myConn.Open()
'create a reader to store the datum which will be returned from the DB
Dim myReader As MySqlDataReader
'Execute your query using .ExecuteReader()
myReader = myCmd.ExecuteReader()
'Reset your List box here.
ListBox1.items.clear()
While (myReader.Read())
'Add the items from db one by one into the list box.
ListBox1.items.add(myReader.GetString(1))
End While
'Close the reader and the connection.
myReader.Close()
myConn.Close()
End Sub
在这一点你有问题吗? – luchosrock 2013-03-23 04:34:16
我不知道如何引入数据! – 2013-03-23 04:51:27
发布我们的代码,你已经尝试过。 – 2013-03-23 04:54:21