public partial class tree : System.Web.UI.Page { public string url = "menu.aspx"; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataTable dt = SQLHelper.DbHelperSQL.GetDataTable("select * from TBLMenu"); SetTreeViewNode(dt, "0000", null); } } private void SetTreeViewNode(DataTable dt,string parentID, TreeNode treeNode) { DataView dv = dt.DefaultView; dv.Sort = "ParentMenuID"; DataRowView[] drvs = dv.FindRows(parentID); if (drvs.Length > 0) { foreach (DataRowView drv in drvs) { String bookCatIDParent = drv["MenuID"].ToString(); String bookCatDesc = drv["MenuName"].ToString(); url = drv["LinkURL"].ToString(); //TreeNode newTreeNode = new TreeNode(bookCatDesc + "[" + bookCatIDParent + "]"); TreeNode newTreeNode = new TreeNode(bookCatDesc); newTreeNode.NavigateUrl = drv["LinkURL"].ToString(); // newTreeNode.Target = drv["target"].ToString(); SetTreeViewNode(dt, bookCatIDParent, newTreeNode); SetTreeView(treeNode, newTreeNode); } } } private void SetTreeView(TreeNode treeNode, TreeNode newTreeNode) { if (treeNode == null) TreeView1.Nodes.Add(newTreeNode); else treeNode.ChildNodes.Add(newTreeNode); } }