[VB.NET] Fill combobox from MySQL!

[aristide]

Hey guys!

I've got a combobox, and I need to fill it up with data from a column in a MySQL table. When one of the cells is selected, the data in the cell in the next row(on the right) is displayed in a textbox. I know how to create a connection, but I can't figure out how to do the rest. I've searched on internet but without brilliant results. Assuming I the table is like this:

Name|Url
Hello | hello.com
BLA | bla.com

Thanks in advance?

[.paul.]

use a dataadapter to fill a datatable + set that datatable as your combobox datasource, + the field name as the combobox displaymember

[aristide]

Thanks. How do I fill a datatable though?

[.paul.]

what do you have so far?
post your code + i'll show you how to modify it

[.paul.]

ok. here's how then:

Dim con As New MySqlConnection("connection string")
Dim da As New MySqlDataAdapter("SELECT * FROM tableName", con)
Dim dt As New DataTable
da.Fill(dt)
ComboBox1.DisplayMember = "fieldName to show in ComboBox"
ComboBox1.DataSource = dt
TextBox1.DataBindings.Add("Text", dt, "fieldName to show in textbox")

[aristide]

ok. here's how then:

Dim con As New MySqlConnection("connection string")
Dim da As New MySqlDataAdapter("SELECT * FROM tableName", con)
Dim dt As New DataTable
da.Fill(dt)
ComboBox1.DisplayMember = "fieldName to show in ComboBox"
ComboBox1.DataSource = dt
TextBox1.DataBindings.Add("Text", dt, "fieldName to show in textbox")

Thanks! For this code, how would the connection string be?
I got this, Dim con As New MySqlConnection("server=localhost; user id=root; password=; database=test")

Is it ok?

[.paul.]

have a look at www.connectionstrings.com