binding a dropdownlist to different data sources

Brian55 0

21y3.4k.NET

I would like to change the contents of a dropdownlist to reflect different selection options. For example, the dropdown box should remain in the same location but it's contents will change depending on what information the user wants to select. The selection will be based on a button. The button will essentially point to a different table. Can I do this? Any code examples?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

sujith 021y ago
This can be done in two ways as per my knowledge. For different button click, you can bind different datasource to the dropdownlist. Code will be something like this: public void Button1_OnClick(object sender, EventArgs e) { DropDownList1.DataSource = DataTable.defaultview; DropDownList1.DataBind(); } public void Button2_OnClick(object sender, EventArgs e) { DropDownList1.DataSource = DataTable.defaultview; DropDownList1.DataBind(); } ******************************************* The other one is using 2 different dropdownlists for different selections. Put each of them in panel () and give ids to the panels. On pageload (only on first load), set their visiblity - one visible and the rest invisible. Now on different button click events bind each of them accordingly and set its visibility as true and rest as false.
RSPERL21y ago
well if this there are multiple buttons on your pages then I would just put the databinding code for the drop down in each buttons OnClick Event Such as public void Button1_OnClick(object sender, EventArgs e) { myDropDownList.DataSource = ds.table[0].defaultview; myDropDownList.DataBind(); } public void Button2_OnClick(object sender, EventArgs e) { myDropDownList.DataSource = ds.Tables[1].defaultview; myDropDownList.DataBind(); } another way woud be to have another drop down or listbox or radio button list and then in which ever control you choose you could implement the different Event Methods DropDownList would be OnSelectedIndexChanged Event Radio button list would be OnItemChanged Event (not quite sure have to look it up to be sure) and then the same if you had a list of tables in a list box too. hope this helps get ya going.