Databinding Dropdownlist to Main Dataset

[jdsharp]

I understand how to bind the Dropdownlist control to a table so that it
shows the list of values, but how do I bind it to my main data entry
dataset?

Thanks for the help!
Jason

 

[Guest]

When you databind a dataset to a dropdownlist or any other bindable control
for that matter, it gets bound to the FIRST table in the dataset.

In order to bind it to any other tables in the dataset you will need to
reference them specifically and bind the actual table to it.

The dropdownlist datasource property will take a dataset as its source just
the same as the datatable.

 

[Dhanushka Nuwan]

dropdownlist1.DataSource = ds;
dropdownlist1.DataMember = ds.Tables[0].TableName;
dropdownlist1.DataTextField = "NAME";
dropdownlist1.DataValueField = "ID";
dropdownlist1.DataBind();

Cheers,

Dhanushka Nuwan
(e-mail address removed)