How do I populate a dropdownbox with a list of tables in a SQL database?

Kyle Brown

Hello all! This is my first post here so hopefully my question is detailed enough for you all to help me. I believe my question is rather simple, however, after much searching I haven't found what I am looking for. What I have is a form with textbox and a datagridview that displays the results entered intot he textbox. What I want is to have a dropdownbox or combobox that my users can select which sql table to search and then enter what they are searching in the textbox. Right now I have to go into the solution and change the sql command to search a specific table and that is a hassle.

Thanks in advance and if I left any details out please let me know without bashing me please.

Kyle

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kyle Brown16y ago
Thanks diya! I had to modify the string a little bit but other than that it worked.

KB
Dipa Ahuja16y ago
hi to get list of tables in drop down you can write :

SqlConnection con;
SqlCommand cmd = new SqlCommand();

string s = ConfigurationManager.ConnectionStrings["Conn"].ConnectionString;

con = new SqlConnection(s);
cmd.CommandText = "SELECT * FROM sys.TABLES";
cmd.Connection = con;
con.Open();
DropDownList1.DataSource = cmd.ExecuteReader();
DropDownList1.DataTextField = "Name";
DropDownList1.DataBind();