Populate a dropdown list from a list of table

I trying to get tables names from my MySQL database to dropdown list box. I have written code for this, it left me some errors. Kindly help

MySqlConnection connect = new MySqlConnection();
connect.ConnectionString = "Data source=localhost;Database=locations;user id=root;password=ietmdb;";

connect.Open();

MySqlCommand cmd = new MySqlCommand("SELECT [Name] FROM TableName, ID TableID FROM locations WHERE xtype = 'u'", connect);
MySqlDataReader dr = cmd.ExecuteReader();

while (dr.Read())
{
DropDownList1.Items.Add(dr.ToString());
}

Re: Populate a dropdown list from a list of table

Could you post the error? Also, try running that query in the MySQL Workbench or command prompt to be sure it works.

Re: Populate a dropdown list from a list of table

venkateshyeluri
DropDownList1.Items.Add(dr.ToString());

while(dr.Read())
            {
                DropDownList1.Items.Add(dr.GetString(0).Trim());
            }

Re: Populate a dropdown list from a list of table

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();

Re: Populate a dropdown list from a list of table

Yeah, you should rewrite your query like this:

"SELECT [TableName].[Name], [TableID].[Locations] from TableName, TableID where [TableName].[xtype] = 'u'"