hi dudes

im writing a asp.net shopping application, useing a SQL backend basicly this is how i want it to work, i have a drop down box that is bound to a nidex table, in this table are 2 columbs, the name of the table & the SQL name of the table, when a user selects a name from that drop down box it fires the dropdownbox change event off, BUT this is what i dont know what to do

in order to fill my datalist i need 2 sql select statments, the first should select sqlname from db.index where strDisplayName=var

thats ok, problem is it returns a dataset, and the only thig i want to come back is a string, so i can then bind that to a variable and use it in the second sql stament to tell it what tabe to open.

any help asap would be amazing coz im strugling with this now dudes

Cheers

Si