1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
| Imports MySql.Data.MySqlClient
Public Class test
Dim MysqlConn As MySqlConnection
Dim COMMAND As MySqlCommand
Dim READER As MySqlDataReader
Dim a As Object
Dim b As Object
Dim c As Object
Private Sub test_Load(sender As Object, e As EventArgs) Handles MyBase.Load
MysqlConn = New MySqlConnection
MysqlConn.ConnectionString =
"server=xxxxxx;userid=xxxx;password=xxxxx;database=xxxxx"
Dim READER As MySqlDataReader
Try
MysqlConn.Open()
Dim Query As String
Query = "select nombre, tipo, ref from xxxx.xxxxx "
COMMAND = New MySqlCommand(Query, MysqlConn)
READER = COMMAND.ExecuteReader
While READER.Read
Dim sProductos = READER.GetString("nombre")
Dim sTipoProductos = READER.GetString("tipo")
Dim sProductosRef = READER.GetString("ref")
ComboBox2.Items.Add(String.Format("{0}|{1}|{2}", sProductos, sTipoProductos, sProductosRef))
End While
Catch ex As Exception
MessageBox.Show(ex.Message)
Finally
MysqlConn.Dispose()
End Try
End Sub
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
TextBox1.Text = ComboBox2.Text(String.Format("{0}"))
TextBox2.Text = ComboBox2.Text(String.Format("{1}"))
End Sub
End Class |
Partager