To display all objects of database in TreeView format

Question

1.50/5 (2 votes)

See more:

Hi,

Can't we show tree view structure in DatagridView using C#?

DataSet ds0 = GetDB1(db1);
DataSet ds1 = GetDB1(db2);
DataSet ds2 = GetDB1(db3);

C#

dgDB1.DataSource = ds0.Tables[0];
               dgDB1.Columns[1].Visible = false;
               lbldb1.Text = "Database: " + ds0.Tables[0].Rows[0][1].ToString();

when i take TreeView control i dont get Datasource for that.
so to show all objects of database in tree view what code should i write?

Eg: my output should be:

+Tables
+Views
+Procedures
+Triggers and so

so when i click on Tables it should show me all tables present.

Posted 27-Jan-14 9:21am

archies_gall

Add a Solution

Comments

Sergey Alexandrovich Kryukov 27-Jan-14 15:33pm

It may or may not be possible to do in a consistent way, because relational model support general object graphs, not just trees.
If you need to show some tree view, use TreeView, or its combination with DataGridView or ListView...
—SA

Charlemagne Gustilo 6-Feb-14 4:25am

Hi, you can try using the following scripts to read items from the database:

select * from sys.tables
select * from sys.views
select * from sys.procedures
select * from sys.triggers

Then you can try adding nodes from the treeview following the sample in http://msdn.microsoft.com/en-us/library/system.windows.forms.treeview(v=vs.110).aspx

Hope this helps.

archies_gall 14-Feb-14 12:11pm

Thank you :)

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)