How to Create a Treeview based on the database

Database Structure ID int (4) primary key parentid int (4) Context nvchar (50) No null
**************************************** *******************************
Function Description
Public void addtree (INT parentid, treenode pnode, Treeview, datatable DT)
The Treeview is the Treeview control and the DT is the table in the dataset.

Call example:

Dt = (datatable) TD. retieretree ();
Addtree (0, (treenode) null, treeview1, DT );

Vs2005 C # Windows XP passed the test.
**************************************** ******************************* Public Void Addtree ( Int Parentid, treenode pnode, Treeview, datatable DT)
{

Dataview dvtree = New Dataview (DT );
// Filter the parentid to obtain all the current child nodes.
// Dvtree. rowfilter = "[parentid] =" + parentid;
Dvtree. rowfilter = " [Parentid] = " + Parentid;


Foreach (Datarowview row In Dvtree)
{

Treenode Node = New Treenode ();
If (Pnode = Null )
{ // Add Root Node
Node. Text = Row [ " Context " ]. Tostring ();
Treeview. nodes. Add (node );
// Node. Expanded = true;
Addtree (int32.parse (row [ " ID " ]. Tostring (), node, Treeview, DT ); // Recurrence
}
Else
{ // Worker Add the subnode of the current node
Node. Text = Row [ " Context " ]. Tostring ();
Pnode. nodes. Add (node );
// Node. Expanded = true;
Addtree (int32.parse (row [ " ID " ]. Tostring (), node, Treeview, DT ); // Recurrence
}
}
}