Develop Parent-Child TreeViews/Lists in asp.net and c#?

Question

Hi  I have two tables in Sql Server Database: Table1: Category - Columns Category_ID categoryName Table2: SubCategory --Columns SubCategory_ID SubCategoryName Category_ID How to create treeviews for each category? Category Table Data: 1 Item1 2 Item2 3 Item3 4 Item4 SubCategory Table Data 1 SubItem1 Item1 2 SubItem2 Item1 3 SubItem3 Item1 4 SubItem4 Item2 5 SubItem5 Item2 6 SubItem6 Item3 7 Subitem7 Item3 How to display the below treeviews/Lists on UI Item1 Item2 Item3 Item4 SubItem1 SubItem4 SubItem6 SubItem2 SubItem5 SubItem7 SubItem3 Please provide me the asp.net and c# code that will generate the above UI. I am new to c#.. Thanks

Satyapriya Nayak · Answer

Hi saradalal Try this... Code Untitled Page using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace TreeView_in_ASP.NET { public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; string str; SqlCommand com com1; protected void Page_Load(object sender EventArgs e) { bindtreeview(); } void bindtreeview() { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = Select * from Category; com = new SqlCommand(str con); SqlDataReader reader = com.ExecuteReader(); com.Dispose(); string[] ParentNode = new string[100 2]; int count = 0; while (reader.Read()) { ParentNode[count 0] = reader.GetValue(reader.GetOrdinal(Category_ID)).ToString(); ParentNode[count++ 1] = reader.GetValue(reader.GetOrdinal(CategoryName)).ToString(); } reader.Close(); for (int loop = 0; loop { TreeNode root = new TreeNode(); root.Text = ParentNode[loop 1]; com1 = new SqlCommand(Select * from SubCategory where Category_ID = + ParentNode[loop 0] con); SqlDataReader reader1 = com1.ExecuteReader(); while (reader1.Read()) { TreeNode child = new TreeNode(); child.Text = reader1.GetValue(reader1.GetOrdinal(SubCategoryName)).ToString(); root.ChildNodes.Add(child); } reader1.Close(); Treeview1.Nodes.Add(root); } Treeview1.CollapseAll(); con.Close(); } } } Thanks If this post helps you mark it as answer