Hi All.

Can i get the values of two tables in dropdownlist??
I have two tables , table1, table2. both has one, one feilds.

table1.name1 and table2.name2.

I want to show values of name1, name2 in the dropdownlist control.

Can some one help me please.

Thanks

zahyea

while (Reader.Read())
{
test.SelectedValue= Reader["xxxx"].ToString(); //table0.name of field
test.SelectedValue= Reader["xxxx"].ToString(); //teble1.name of field
}

You can use a dataset to combine the values of the 2 tables using a valid query.Then bing the control to the dataset.This can help in cases where the two tables have datarelations