Complex Bind Combo Box VB.Net

[Travis]

I am new to VB.NET and I am trying to use a complex bind for a combo
box. I have successfully created a data set, I have set my DataSource
value to the dataset and the DisplayMember value to the field in the
dataset I wish to utilize. When I run the form the combo box has no
information. What am I doing wrong?

Thanks!!
Travis

[Ken Tucker [MVP]]

Hi,

You should use a datasource of dataset.table.

Here is an example Assumes you import system.data.ole db

Dim conn As OleDbConnection

Dim strConn As String

Dim strSQL As String

Dim da As OleDbDataAdapte r

strConn = "Provider = Microsoft.Jet.O LEDB.4.0;"

strConn += "Data Source = Northwind.mdb;"

conn = New OleDbConnection (strConn)

da = New OleDbDataAdapte r("Select * From Categories", conn)

da.Fill(ds, "Categories ")

ComboBox1.DataS ource = ds.Tables("Cate gories")

ComboBox1.Displ ayMember = "CategoryNa me"

Ken
--------------------
"Travis" <su*****@dekate chnologies.com> wrote in message
news:15******** *************** ***@posting.goo gle.com...

I am new to VB.NET and I am trying to use a complex bind for a combo
box. I have successfully created a data set, I have set my DataSource
value to the dataset and the DisplayMember value to the field in the
dataset I wish to utilize. When I run the form the combo box has no
information. What am I doing wrong?

Thanks!!
Travis

[Cor]

Hi Travis,

You have to set the datasource to a dataset table when you use a dataset not
the dataset itself.
something as
\\\
combobox1.datas ource = dataset.tables( "mytable")
///

I hope this helps,

Cor

I am new to VB.NET and I am trying to use a complex bind for a combo
box. I have successfully created a data set, I have set my DataSource
value to the dataset and the DisplayMember value to the field in the
dataset I wish to utilize. When I run the form the combo box has no
information. What am I doing wrong?