TreeView from datatable

Question

0.00/5 (No votes)

See more:

VS2010

, +

I'm searching for a solution where i can fill a treeview in my WinForm from a datatable that has no parent and child ID's but is sorted the right way in the query. The first column is the parent and the second column is the child. Column 3 is the child from the second column etc. duplicate values need to be filtered out. The datatable is filled with a query from a sql database.

Table

Column1     Column2     Column3
A.............1...............1
A.............2...............1
A.............2...............2
B.............1...............2

Tree

A-1-1
...-2-1
.....-2
B-1-2

Thanks everybody

Posted 1-Aug-13 22:49pm

DannyIO

Updated 1-Aug-13 23:12pm

v4

Add a Solution

Comments

Maciej Los 2-Aug-13 5:04am

WinForms, WebControls?

DannyIO 2-Aug-13 5:08am

It's for a WinForm, Thanks

David_Wimbley 4-Aug-13 1:56am

The quick and dirty way would probably be to loop over the contents of your data table and add the nodes programmatically.

So you will first need to set a root node as you don't have one

rootNode = treeView1.Nodes.Add("Root Node");

Then you would say something like

If reader.read == column1 && reader.read == "A"
subNode = new TreeNode(reader.Read("Column2");
rootNode.Nodes.Add(subNode);

Then for your filtering out of data it would be something like

If reader.read == "column1" && reader.read == "A" && reader.read == "2"
subNode = new TreeNode(reader.Read("Column3");
subNode.Nodes.Add(subSubNode);

Something along those lines.

I did not post this as solution as it is merely meant to give you an idea to steer you in a particular direction. Although it would be easier to not use a data table and just adjust the queries you are running to get data out of SQL since the format you've given is providing a difficult constraint to work with

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)