Asp. NET Recursive Add tree node

Table Design:

ID Title ParentID

1 ASP. 0

2 C # 0

3 C#_0 2

4 C#_1 3

5 C#_2 4

Add a TreeView control to the page

Write Add Node Method:

private void AddNode (int id, TreeNode parentnode)

{

String sql = "Select * from menu";//sql statement

DataTable table = DB. GETDB (SQL);//Get Data

DataView view = new DataView (table);//Add table data to Custom view

View. RowFilter = "Parentid=" +id;//set view query criteria

foreach (DataRowView row in view)//Traverse data in view

{TreeNode node = new TreeNode ();

Node. Text = row[1]. ToString ();

int newid = Convert.ToInt32 (row[0]);

if (parentnode! = null)
{

Node. Expanded = false;

ParentNode. Childnodes.add (node);

AddNode (newid, node);//Recursive lookup node

}

Else

{

TREEVIEW1.NODES.ADD (node);

AddNode (newid, node);

}

}

}

The Getdb () method in the DB class:

public static SqlConnection Sqlconn ()

{String sqlconnstr = "Database=menutree;data source=.; Uid=sa;pwd=123 ";

SqlConnection conn = new SqlConnection (SQLCONNSTR);     Return conn; }

public static DataTable Getdb (String sql)

{SqlConnection connection = sqlconn ();

SqlCommand comm = new SqlCommand (sql, connection);

SqlDataAdapter ad = new SqlDataAdapter (comm);

DataTable table = new DataTable ();

Ad. Fill (table);

return table; }

Calling code:

protected void Page_Load (object sender, EventArgs e)

{if (! IsPostBack)

{TreeView1.Nodes.Clear ();

AddNode (0, (TreeNode) null);
}     }

Complete!

Asp. NET Recursive Add tree node