Dynamic Loading of ultrawebtree

The database table structure is:

Table Name: treetable
Field: l_id: primary key ID
L_name: name of the menu displayed in the tree
P_l_id: A menu
Rochelle page: directed path
Rochelle pagename: File Name

Sample Data:

Rochelle ID	L_name	P_l_id	Rochelle page	Rochelle pagename
1	Root 1	0	.....
2	Root 2	0	......
3	Sub11	1	...
4	Sub12	1
5	Sub13	1
6	Sub21	2

 

// Initialize tree menu
Private   Void Databindtree ()
... {
Dataconn DC = New Dataconn (specialclass. strconn ); // Make a data connection here and change it to your own connection.
Datatable dt = New Datatable ();
// Query the data in the table and construct it as a able
DT = DC. getdatatable ( " Select l_id, l_name, p_l_id, (l_page + l_pagename) as urlpath from treetable " );
Inittree ( This . Ultrawebtree1.nodes, " 0 " , DT );
// Expand Tree
Tvwitems. expandall ();
}

Private   Void Inittree (infragistics. webui. ultrawebnavigator. nodes NDS, String PID, datatable data)
... {
Infragistics. webui. ultrawebnavigator. node tmpnd;
Datarow [] rows = Data. Select ( " P_l_id =' "   + PID +   " ' " );
Foreach (Datarow row In Rows)
... {
Tmpnd =   New Infragistics. webui. ultrawebnavigator. node ();
Tmpnd. datakey = Row [ " Rochelle ID " ]. Tostring (); // ID
Tmpnd. Text = Row [ " L_name " ]. Tostring (); // Node name
Tmpnd. TargetUrl = Row [ " Urlpath " ]. Tostring (); // Path + Page
Tmpnd. targetframe = " Main " ; // Oriented target framework
NDS. Add (tmpnd );
Inittree (tmpnd. nodes, tmpnd. datakey. tostring (), data );
}
}