add all table names from mysql database to my project in VB.NET

[mrani]

hi everybody
i just want to know how i can add all the table names present in that particular database in my vb.net project.
i want to display all the table names in the combobox.
butri have the query by which we can slect all the tables.this is:

sql = "select * from Employee.information_schema.tables"

but i have a problem to add all that tables names to combo box.plz help me
thnakx in advance

 

[DavidT_macktool]

DataTable of Datatables

Have you considered creating a table that has the names of the datatables in it? No hard coded values to be recoded, and one central location easy to add edit and delete from. Bind your combobox to this table and continue on your merry way.