How to bind the data of a data table to a treeview control

This ** is very precious, send it to you!

It is for the purpose of compiling only and the specific content of the database, such as fields, is of no practical significance to you.

private void load_categorytree()

dataset dscatnode= get_treeviewdata();You need to provide the data source yourself.

foreach (datarow dr in

guid? parent = null;

if (dr["parentid"] !=

parent = (guid)dr["parentid"];

if (parent == null ||parent == only the top layer.

treenode newnode = new treenode();

dr["txttext"].tostring();

dr["name"].tostring();

dr["id"].tostring();

tv_;add_child(newnode, "select"].rows);Recursively add child nodes.

Recursively add child nodes.

private void add_child(treenode node, datarowcollection drs)

if (node == null) return;

if (drs == null) return;

int count = ;

if (count < 1) return;

guid? id = new guid(;

foreach (datarow r in drs)

guid? parent = null;

if (r["parentid"] !=

parent = (guid)r["parentid"];

if (parent == id)

treenode newnode = new treenode();

r["txttext"].tostring();

r["name"].tostring();

r["id"].tostring();

add_child(newnode, drs);Recursion.

Is it going to be loaded all at once or dynamically graded by step?

treenode rootnode=new treenode();

In this way, the root node is added, and the child nodes are also the same square method.

Yu Dan Ran whispered sentence: ;

Where: parentnode: parent node.

childnodes: vs the default parent node property, which is used to obtain the first-level child node of the parent node.

add: vs the default method of adding nodes.

childnode: The child node to be inserted.

The first step is to populate the root node and select distinct customer from

Populate each node with a child node (the key can be special so that the following programming time can identify whether the node has been populated or not).

Step 2: When you click a node, determine whether it needs to be filled according to its child nodes, select distinct model from where customer =

Fill each node of the pants stall with a child node (the key can be special so that the following programming can identify whether the node has been populated or not).

And so on.

The datatable data found in the three tables is returned in the dataset, and then the data is displayed in the node in the loop dataset.

For your few tables, it is not possible to bind them directly.

The data source of the treeview should have (own ID, display column, data column, own parent ID).

--Parent node.

treenode mytreenode = new treenode("q");

createchildtree(mytreenode);

Add a child node.

public void createchildtree(treenode parentnode)

Complete** don't need it.

The tree is tied like this.

For example, if you query pid=0 and return the result listparentlistfor(int i=0; I can use whatever you want.

For example, the object key Chang list returns a list

if(>0)

foreach(listin list)

treenode child=new treenode();

Here you set the displayed text yourself.

Here is the value of the setting node.

bindtreechildnode(child);Continue to recursively call yourself to add child nodes.

The tree is tied in this way

10 points is too little to estimate, but I can tell you the idea.

Handful. for loop.

Find out the root node, and then loop the child node in each root node to find the limb high pin, and then add the child node to the root node, and then go through the root node.

Bonding Thoughts. to the tree

treenode tno = new treenode("root");

datatable dt = new datatable();

id");name");

category");

1", "Civil Affairs Person", "Political outlook");

2", "Other parties", "Political outlook");

3", "Dr", "Education");

4", "Master's degree", "Education");

5", "Undergraduate", "Education");

6", "Junior College", "Education");

datatable categorytable = , new string );

foreach (datarow category inforeach (treenode item in;

Traversing the data in the database, the treenode object is added to the nodes property of the treeview, and the nodes property of the treenode object can also be added, so that a tree-like structure is formed, and the recursive algorithm is generally used to bind the treeview control.