tree view control

Ruchi R

17y6.1k.NET

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

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nilanka Dharmadasa16y ago
Accepted 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.
0
Ruchi R16y ago
thanks niki, its working .
0
Ruchi R16y ago
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.
0
Ruchi R16y ago
Thanks niki it worked thanks a lot
0
Nilanka Dharmadasa16y ago
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.

0
Ruchi R16y ago
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.
0
Nilanka Dharmadasa17y ago
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.
0
Ruchi R17y ago
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??????/
0
Srinivas Kotra17y ago
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
0
Lalit M17y ago
try this link

http://www.aspnettutorials.com/tutorials/controls/treeview-node-aspnet2-csharp.aspx

http://support.microsoft.com/kb/320909
0