hi

i think your problem might be with your SQL statement. i see that you are using "FROM" 2 times.

""SELECT [Name] FROM TableName, ID TableID FROM locations WHERE xtype = 'u'"""

i dont think this syntax is incorrect.

i would also sugest to put the result into a datatable a bind it to the dropdownbox.

something like :

mysqldataadapter a = new mysqldataadapter("SELECT.....",connect);

datatable b = new datatable();

a.fill(b);

dropdownlist.datasource =  b;

dropdownlist.databind();