tree view control

Question

hi how to populate a tree view control from database dynamically.after populating tree view i need to open or give a link to each child node(which is populated from database) to a different aspx pages i am using c#.net and sql for this hoping for ur help

Nilanka Dharmadasa · Answer

Hi Ruchi, Then each child's page should have a common format. Ex: child a >> a.aspx child b >> b.aspx If you can use the name of the child as the name of the page as mentioned above, then we can write the code as follows. TreeNode cNode = new TreeNode(CRow["Dept_Name"].ToString()); cNode.NavigateUrl = string.Format("{0}.aspx",CRow["Dept_Name"].ToString()); PNode.ChildNodes.Add(cNode); Hope this will resolve your problem.

Nilanka Dharmadasa · Answer

Hi Ruchi, It's simple. Change your code as follows.Focus on the lines in color blue. Other part is the code written by you. protected void Page_Load(object sender, EventArgs e) { string conn = ConfigurationSettings.AppSettings["SqlConn"]; SqlConnection MyConn = new SqlConnection(conn); SqlCommand Mycomm = new SqlCommand("SELECT tblCompany.Comp_Name, tblDepartment.Dept_Name FROM tblCompany INNER JOIN tblDepartment ON tblCompany.Comp_Id = tblDepartment.Comp_Id", MyConn); SqlDataAdapter Dadapter = new SqlDataAdapter(Mycomm); DataSet Ds1 = new DataSet(); Dadapter.Fill(Ds1, "tblCompany"); foreach (DataRow PRow in Ds1.Tables["tblCompany"].Rows) { TreeNode PNode = new TreeNode(PRow["Comp_Name"].ToString()); this.TreeView1.Nodes.Add(PNode); PNode.NavigateUrl = "Default2.aspx"; foreach (DataRow CRow in Ds1.Tables["tblCompany"].Rows) { TreeNode cNode = new TreeNode(CRow["Dept_Name"].ToString()); cNode.NavigateUrl = "";//Give the url of the child here. PNode.ChildNodes.Add(cNode); } PNode.Collapse(); } Ds1.Dispose(); Dadapter = null; MyConn.Close(); MyConn = null; } If you find any problem pls ask. I'm ready to help. If you find this answer helpful, please check 'Do you like this answer' checkbox.

Ruchi R · Answer

thanks niki, its working .

Ruchi R · Answer

hi niki That answer worked, thanks a lot for that. But i got one more problem ,actually child nodes should directs to differnt pages.according to the above answer childnodes can direct to only one page.for example,' a' childnode directed to a.aspx page and 'b' child node should direct to b.aspx page like wise other child node directs to their respective pages. what should i do for it.

Ruchi R · Answer

Thanks niki it worked thanks a lot

Ruchi R · Answer

HI NIKI Thanks for ur reply PNode.NavigateUrl="Default.aspx"; directs to the Default.aspx page . where PNode means Parent nodes. now i need to make links to the childnodes of that parent nodes, so that child nodes also directs to its respective pages like Parentnode(PNode). Suppose A, B, C are parent nodes.and a,b,c are child nodes of those Parent nodes A B C.here in my project child nodes for three of A,B,C are same.now i need to make a links to child nodes a,b,c so that it could also directs to its respective pages. what should i do for it.

Nilanka Dharmadasa · Answer

Hi Ruchi, It seems, what you have done is correct. If you have set the following property, when you click on that node, it will direct to that page. PNode.NavigateUrl = "Default2.aspx"; So tell me what's the problem? Please be more specific. :) I hope I can help you.

Ruchi R · Answer

i visited that site but that didnot help me. Actually i have populated a tree view control of asp.net from the data base. the code is as shown below: protected void Page_Load(object sender, EventArgs e) { string conn = ConfigurationSettings.AppSettings["SqlConn"]; SqlConnection MyConn = new SqlConnection(conn); SqlCommand Mycomm = new SqlCommand("SELECT tblCompany.Comp_Name, tblDepartment.Dept_Name FROM tblCompany INNER JOIN tblDepartment ON tblCompany.Comp_Id = tblDepartment.Comp_Id", MyConn); SqlDataAdapter Dadapter = new SqlDataAdapter(Mycomm); DataSet Ds1 = new DataSet(); Dadapter.Fill(Ds1, "tblCompany"); foreach (DataRow PRow in Ds1.Tables["tblCompany"].Rows) { TreeNode PNode = new TreeNode(PRow["Comp_Name"].ToString()); this.TreeView1.Nodes.Add(PNode); PNode.NavigateUrl = "Default2.aspx"; foreach (DataRow CRow in Ds1.Tables["tblCompany"].Rows) { PNode.ChildNodes.Add(new TreeNode(CRow["Dept_Name"].ToString())); } PNode.Collapse(); } Ds1.Dispose(); Dadapter = null; MyConn.Close(); MyConn = null; } now what i need to do is when a user click on a child node it should display its respective pages. how should i do it??????/

Srinivas Kotra · Answer

Hi, this links may helps you http://asp-net-example.blogspot.com/2009/04/how-to-get-checked-node-text-and.html http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.treenode.navigateurl.aspx

Lalit M · Answer

try this link http://www.aspnettutorials.com/tutorials/controls/treeview-node-aspnet2-csharp.aspx http://support.microsoft.com/kb/320909

tree view control

Answers (10)