To bind a dropdownlist with 2 columns from different tables.

[hiranmaie]

I have a dropdownlist by name dropdownlist1. I have two tables by name table1 and table2.
I want to bind the value1s from TName1 column of table1 and TName2 column of table2.

If there are 10 values (10 - rows) in table1 and 15 values (15 - rows) in table2.
I want the dropdownlist to show 25 values (25 - rows), which include from both 1st and 2nd table values.


Please help.