Here i got the problem with sql query to get the values in the drop down list box.
This is the query i used to get the result in sql.
so the same values i need in drop down list box..
this is my sql query
sql="select col1 from table1 union all select col2 from table2
can anyone give a clue to get the list box values..
If i use the same query ,i can't give two column names in list box..