Search:

Jonny,

Thanks for the excellent reply. I figured something a little more straighforward.


// create query
string qryEvents = @"select EventID,Name from Events order by Name";...

I can populate the drop down list no problem. What I want to do is save the selected data into another table which is related via foreign key. So I want the list to show the text description(Name)...