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());
}
venkateshyel...
Member
12 Points
29 Posts
Populate a dropdown list from a list of table
Apr 13, 2012 04:26 PM|LINK
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());
}