Set combobox to database

[Chong]

Will anyone show me how to set a combobox to a database data? Here's what I have. I have a Dataset1 and a DataAdapter1. In design mode:

combobox1.DataSource = Dataset1
combobox1.DisplayMember = DataSet1.SerialNumber

Under DataBind settings:
Selected Item set to: DataSet1 - Computer.SerialNumber
Selected Value set to: DataSet1 - Computer.SerialNumber
Text set to: DataSet1 - Computer.SerialNumber

But so far this hasn't work. The combobox didn't display anything serial number at all.

Many thanks for trying to help.

ljCharlie

[Edneeis]

combobox1.DataSource = Dataset1 'this should be the table too tables(0) by default 
combobox1.DisplayMember = "SerialNumber"

[Chong]

Thanks! I got it working now. The problem I have was I did a fill with DataAdapter.fill(DataSet1, "myTable") and that is why it won't show up in my combobox.

ljCharlie