How to load data from database to TreeView
How to load data from database to TreeView
Introduction
How to load data from database into the Treeview control
1-Create two table as show below
Table ParentTable
ChildTable
2-Add some data
ParentTable
ChildTable
Drag and drap a TreeView control on the web page
As show below
3-Copy the below listed code in the aspx.cs page
//Code Detail protected void Page_Load(object sender, EventArgs e) { fill_Tree2(); } void fill_Tree2() { DataSet PrSet = PDataset("Select * from ParentTable"); TreeView1.Nodes.Clear(); foreach (DataRow dr in PrSet.Tables[0].Rows) { TreeNode tnParent = new TreeNode(); tnParent.Text = dr["ParentName"].ToString(); tnParent.Value = dr["ParentID"].ToString(); tnParent.PopulateOnDemand = true; tnParent.ToolTip = "Click to get Child"; tnParent.SelectAction = TreeNodeSelectAction.SelectExpand; tnParent.Expand(); tnParent.Selected = true; TreeView1.Nodes.Add(tnParent); FillChild(tnParent, tnParent.Value); } } public void FillChild(TreeNode parent,string ParentId) { DataSet ds = PDataset("Select * from ChildTable where ParentId =" + ParentId); parent.ChildNodes.Clear(); foreach (DataRow dr in ds.Tables[0].Rows) { TreeNode child = new TreeNode(); child.Text = dr["ChildName"].ToString().Trim(); child.Value = dr["ChildId"].ToString().Trim(); if (child.ChildNodes.Count == 0) { child.PopulateOnDemand = true; } child.ToolTip = "Click to get Child"; child.SelectAction = TreeNodeSelectAction.SelectExpand; child.CollapseAll(); parent.ChildNodes.Add(child); } } protected DataSet PDataset(string Select_Statement) { SqlConnection SqlCon = new SqlConnection("Data Source=;Integrated Security=True"); SqlDataAdapter ad = new SqlDataAdapter(Select_Statement, SqlCon); DataSet ds = new DataSet(); ad.Fill(ds); return ds; }
Points of Interest
Learn new control
History
Keep a running update of any changes or improvements you've made here.