how do you fill a combobox with databasefields?
Printable View
how do you fill a combobox with databasefields?
This is how i did it sucking data from SQlServer 2000
In a windows application you would create a dataset (ds)
create a sqldataadapter (da)
then set the DataSource of your combo box to the content you want(eg ds.TypeValue)
- DisplayMember to the value
- ValueMember to the same value.
- Also set the DropDownStyle to DropDownList.
then in code (on button_click, FormLoad etc)
ds.Clear()
da.Fill(ds, "TypeValue")
where typevalue is the column from the table you are accessing in the dataset
sorry if it seems badly explained but i am just learning myself