Populate Treeview with all tables and columns of a database from dataset

Question

I am new in VB. I need to load the tables and columns of a database into a windows form treeview. I know how to bring the information back as a dataset but all the stuff online doesn't show how to load all the tables in a database(as parent) and all the columns (as child) in the the treeview as a dataset. I have to allow the person to build their SQL statment from the things they select in the treeview. I can't get the treeview working, let alone trying to work on the rest.

Nir Bar · Answer

Hi TreeView is a rather hard control to work with. It isn't meant to be used as data-bound control I suggest you work with a DataGridView. If you need the check-boxes for selection you can create a non-bound (DataPropertyMember=null) DataGridViewCheckBoxColumn To bind the DataGridView to a table you do DataGridView.DataSource = DataTable For every column you want to display you add a DataGridViewColumn (there are several types of columns available) to the grid's Columns collection If you get more specific on what you need I can help you better Please check Accepted Answer if this post helps you Nir

Theresa · Answer

I'm new to vb also and trying to do the exact same thing. I've gotten the 1st level - Table names - to populate in treeview but not sure how to add the columns as child rows. Can you help?

keepafloat · Answer

I figured it out. Thanks for your assistance in trying to help. I wanted to create a treeview directory per say to see a databases table and columns. I did it the SQL database. 1. fed in connection string with database 2. Used the SQL statement with the Select being the tables and columns FROM coming from the Iformation_Schema.Columns did a subquery in the where to get the table names from the sysobjects where type ='U' 3. Brought this table in with the names Table and Columns as a dataset 4.. Then populated the Treeview from the dataset I still need to learn how to do it for other types of databases but atleast this is a start.

Nir Bar · Answer

Then you'll have to do it manualy - assigning text to each node of the tree I'm afraid there isn't any shortcut that I'm aware of Good luck Nir

keepafloat · Answer

Unfortunately I have to use the treeview to show all table names and their columns. The customer wants it that way. I don't want to bind it. I want to look into the database pull out all the table names and all columns