Making Treeview on Button Click

Question

0.00/5 (No votes)

See more:

My Form APplication contains Button,TextBox,Treeview and a Table that contains
columns MenuID,FormName,Assembly,Caption,ParentID,OrderNo,Deleted.
Here are some sql queries,

select * from  tblMenu where menuid=87
select * from  tblMenu where menuid=23
select * from  tblMenu where menuid=1
select * from  tblMenu where menuid=0

Results:

MenuID       ParentID 
 
87              23
23              1
1               0    
0          	0

Look at query result, MenuID 87 have ParentID 23, then MenuID 23 have parentID1, then MenuID 1 have parentID 0.
when i write any MenuID in textbox then it shows the all the ParentID, like in above question when i write 87 in the
textbox it make the treeview of all ParentID 0,1,23.
Kindly tell me through coding.thanks
Hope now you can better understand my question.
kindly help me that how that is possible through coding,

Please help me, thanks.

Posted 18-Oct-11 1:15am

bilawal121

Updated 19-Oct-11 0:27am

v9

Add a Solution

Comments

Xeshan Ahmed 18-Oct-11 8:09am

you want to make tree-view in what order plx do elaborate this question

bilawal121 19-Oct-11 6:22am

My Form APplication contains Button,TextBox,Treeview and a Table that contains
columns MenuID,FormName,Assembly,Caption,ParentID,OrderNo,Deleted.
Here are some sql queries,
<pre>
select * from tblMenu where menuid=87
select * from tblMenu where menuid=23
select * from tblMenu where menuid=1
select * from tblMenu where menuid=0
</pre>

Results:
<pre>
MenuID ParentID

87 23
23 1
1 0
0 0
</pre>

Look at query result, MenuID 87 have ParentID 23, then MenuID 23 have parentID1, then MenuID 1 have parentID 0.
when i write any MenuID in textbox then it shows the all the ParentID, like in above question when i write 87 in the
textbox it make the treeview of all ParentID 0,1,23.

Hope now you can better understand my question.
kindly help me that how that is possible through coding,

Please help me, thanks.

BillWoodruff 18-Oct-11 19:53pm

I don't understand what your question is. You are, evidently, adding items to a TreeView based on geting a number in a TextBox and looking up the corresponding record in a Table. So what's going wrong ? What's the error ?

bilawal121 19-Oct-11 6:23am

My Form APplication contains Button,TextBox,Treeview and a Table that contains
columns MenuID,FormName,Assembly,Caption,ParentID,OrderNo,Deleted.
Here are some sql queries,
<pre>
select * from tblMenu where menuid=87
select * from tblMenu where menuid=23
select * from tblMenu where menuid=1
select * from tblMenu where menuid=0
</pre>

Results:
<pre>
MenuID ParentID

87 23
23 1
1 0
0 0
</pre>

Look at query result, MenuID 87 have ParentID 23, then MenuID 23 have parentID1, then MenuID 1 have parentID 0.
when i write any MenuID in textbox then it shows the all the ParentID, like in above question when i write 87 in the
textbox it make the treeview of all ParentID 0,1,23.

Hope now you can better understand my question.
kindly help me that how that is possible through coding,

Please help me, thanks.

BillWoodruff 19-Oct-11 7:25am

So you want to create a TreeView like this:

23
87
1
23
0
1
0

?

bilawal121 19-Oct-11 7:36am

no sir i want to make treeview of ParentID like this
0
1
23
o parent of 1, and 1 parent of 23.

BillWoodruff 19-Oct-11 9:18am

So it appears you want a TreeView with sorted parent nodes in ascending numeric sequence ? What does it mean that zero is also the parent of zero, and what about 87 ?

Can we assume that when you pull this data out for a given record that the list of MenuID=>ParentID you need to parse is any particular kind of order ?

bilawal121 20-Oct-11 4:47am

Yes sir we store parentID in ascending order,leave 0 is parent of zero.
i want to make Treeview of ParentID

BillWoodruff 20-Oct-11 7:02am

When I look at your queries, it seems you are pulling out the records with MenuID as the selector, and that leads to an assumption ... perhaps wrong ... that the ParentID's will not be in any particular order.

I'm afraid I'm not being much help to you here, but is it the case that this group of records you extract is a collection which you can iterate over with 'foreach ?

In other words do you have something like a List<Queryresult>, and you can do a foreach iteration over that collection, and, for each QueryResult, you have the properties ParentID and MenuID available just by using dot notation: i.e.,

// do whatever to create the collection
List<QueryResult> QueryResults = ???;

foreach (QueryResult theQueryResult in QueryResults)
{
int MenuID = theQueryResult.MenuID;
int ParentID = theQueryResult.ParentID;
}

bilawal121 20-Oct-11 7:03am

Sir i have completed my task aproximately half,
i get all the ParentId against the MenuId i have enter,
like i enter MenuID=87 it gives me all the ParentId's like 0,1,23 .
sir kindly tell me the treeview of that ParentID's
like this
0
1
23
0 should be parent of 1,and 1 should be parent of 23.

3 solutions

Solution 2

First, if the structure is conventional, order the queries by ID so each node's parent is already available when that node is created. Then, pseudocode:

Map<int,Node> nodes;
nodes[0] = new Node("Root");
foreach(TableRow row in table){
 Node node = new Node(row.Text); // you have a text column right?
 Node parent = nodes[row.ParentID];
 parent.Children.Add(node);
 nodes[row.MenuID] = node;
}

Posted 19-Oct-11 1:22am

BobJanova

Solution 1

You need 2 methods, the first method creates the nodes for the records that have 0 as the parent. I put the record into the tag property of the node (TreeViewItem I believe)

The second method receives the parent node and looks for and records with the parentID matching the record in the tag property of the parent node passed in.

Having added the child node the second method then calls itself (recursive processing) passing in the newly created node as the parent.

This allows you to build a treeview of any depth. Also the supporting object now resides in the tag property and can be used when you need to interact with the treeview.

Posted 18-Oct-11 20:56pm

Mycroft Holmes

Comments

bilawal121 19-Oct-11 6:23am

kindly tell me the solution through coding

Mycroft Holmes 19-Oct-11 6:51am

Sorry I don't have the time nor the inclination to do your work for you

bilawal121 20-Oct-11 7:08am

Sir i have completed my task aproximately half,
i get all the ParentId against the MenuId i have enter,
like i enter MenuID=87 it gives me all the ParentId's like 0,1,23 .
sir kindly tell me the treeview of that ParentID's
like this
0
1
23
0 should be parent of 1,and 1 should be parent of 23.

Add a Solution

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)

BillWoodruff · Accepted Answer · 2011-10-20T02:31:00

See if this helps you get started:

XML

// put a TreeView named 'treeView1 on a WinForm
// put a Button named 'button 1 on the Form
// set 'button1's Click Event handler
// to button1_Click in the design-time Properties/Events facility
// run the project, click the button: observe
//
private TreeNodeCollection TNCollection;

private TreeNode node1;

private void BuildTree(List<int> intList )
{
    TNCollection = treeView1.Nodes;

    // edit #1 : sort the list of integers
    intList.Sort();

    foreach (int theInt in intList)
    {
        node1 = new TreeNode(theInt.ToString());
        TNCollection.Add(node1);
        TNCollection = node1.Nodes;
    }

    treeView1.ExpandAll();
}

private void button1_Click(object sender, EventArgs e)
{
    // edit #1: list of integers now scrambled to demonstrate
    // sorting the list works, and that duplicates are handled
    BuildTree(new List<int> {23, 1, 0, 44, 87, 0, 23});
}