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.