Add Data to Tree View from Database in asp.net (C#)

Question

I all way have problem with show data in Tree View. I want to show data from database into Tree View Can help me this problem? Thank Advance,.

Niradhip Chakraborty · Answer

check out: 1.http://www.codeproject.com/KB/aspnet/FillTreeView.aspx 2.http://www.codeproject.com/KB/aspnet/FillTreeView.aspx?display=PrintAll

meli · Answer

BTW, here is the example of the code: private void fill_Tree() { /* * Fill the treeview control Root Nodes From Parent Table * and child nodes from ChildTables */ SqlConnection SqlCon = new SqlConnection (connection); SqlCon.Open(); /* * Query the database */ SqlCommand SqlCmd = new SqlCommand ( "Select * from PrentTable" , SqlCon); /* *Define and Populate the SQL DataReader */ SqlDataReader Sdr = SqlCmd.ExecuteReader(); /* * Dispose the SQL Command to release resources */ SqlCmd.Dispose(); /* * Initialize the string ParentNode.*/ string [,] ParentNode = new string [100, 2]; int count = 0; while (Sdr.Read()) { ParentNode[count, 0] = Sdr.GetValue(Sdr.GetOrdinal( "PKinParentTbl" )).ToString(); ParentNode[count++, 1] = Sdr.GetValue(Sdr.GetOrdinal( "ColumValue" )).ToString(); } Sdr.Close(); for ( int loop = 0; loop { TreeNode root = new TreeNode (); root.Text = ParentNode[loop, 1]; /* * Give the url of your page */ root.NavigateUrl = "~/TreeView.aspx" ; SqlCommand Module_SqlCmd = new SqlCommand ( "Select * from ChildTable where ID =" + ParentNode[loop, 0] + "ORDER BY Description ASC" , SqlCon); SqlDataReader Module_Sdr = Module_SqlCmd.ExecuteReader(); while (Module_Sdr.Read()) { TreeNode child = new TreeNode (); child.Text = Module_Sdr.GetValue(Module_Sdr.GetOrdinal( "Description" )).ToString(); child.Target = "_blank" ; //get the url string url = Module_Sdr.GetValue(Module_Sdr.GetOrdinal( "ChildColValue" )).ToString(); if (url != null ) child.NavigateUrl = url; root.ChildNodes.Add(child); } Module_Sdr.Close(); // Add root node to TreeView TreeView1.Nodes.Add(root); } /* * By Default, when you populate TreeView Control programmatically, it expends all nodes. */ TreeView1.CollapseAll(); SqlCon.Close(); }

meli · Answer

Hi, I have did similar thing on one of my page, where I build the "tree view" from the database. In my case, I have 2 tables (parent table nad child table) and read them in using SQLDataReader, and then loop through it to fill out the tree.

Add Data to Tree View from Database in asp.net (C#)

Answers (3)