I am populating a dropdownlist of cities from the table and checking whether the city is matching the value from another table and want to show it as selected item. Here I am not using any numeric identity for the city so I can't use the selectedindex property of dropdownlist.

[We can easily generate code in asp using while and if iterations to display the city that is matching in both table]

I used all the methods of Oledbdatareader and Dropdownlist but it is showing only the index-0 as the selected item.

Can anybody help me to solve the problem?

SK

__________________
Thanks in advance.

Regards,

Senthil Kumar M.

Finally I found out a solution by iterating the thing through a for loop with the total count of data in the dropdown list.

Thank you.

SK