Drop Down List help please

[ummaria]

Hello

I have a drop down list that retrieves data from a data base.
Under that I have a textbox that I want to retrieve information also from the database depending on the previously selected item.

For example, if i select "Computer" from the dropdown list, the textbox should display "PC".

This is part of my graduation project and I really need help.
Thanks :)

[avkdsiva]

public static void LoadCombo(DropDownList cmb,string KeyCodeColumn,string KeyNameColumn,string TableName,DataSet ds)
{
cmb.Items.Clear();
foreach (DataRow dr in ds.Tables[TableName].Rows)
{
ListItem ls = new ListItem(dr[KeyNameColumn].ToString().Trim());
if (KeyCodeColumn != "")
ls.Value = dr[KeyCodeColumn].ToString().Trim();
cmb.Items.Add(ls);
}
}

Now, if you want to display the value of the selected item in the textbox1, you can show it using
textbox1.text = cmb.SelectedValue;

[nmsreddi]

Hello

If your data is limited and static then you can go for arraylist colletion other if

you want the data to get from database then simply you can use auto postback

property of the combobox and write the code in combo selected index changed

event for each time bind that corresponding data to the textbox its not a problem


Good luck