TreeView Control displaying Sql Table Data

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

I want to create a TreeView Control. It will Display the SQL Table Data.
I have one table Named as DealerDetails.
It contains DealerCode and Location.
What I want is for Location to be the parent Node and DealerCode to work as a ChildNode.
Same Locations DealerCode should appear under the Location Node.

I want to populate the TreeView using SQL Data.

Please help me.

Posted 6-Jan-12 9:01am

Sourav Sarkar-SS

Updated 7-Jan-12 5:43am

v3

Add a Solution

Comments

Kschuler 6-Jan-12 16:49pm

You haven't asked a question. What are you having trouble with?

[no name] 7-Jan-12 11:13am

My first sentence is my Question.
how can I populate a tree view using SQL data.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Vivek Krishnamurthy · Answer 1 · 2012-01-07T07:45:00

Since your question is openended, providing a precise solution could be difficult.

If you need a wpf or winforms based solution, this could be one of the many approach:

1. Load all the data you want from the sql server into datasets

2. Make sure you have all the relations defined on them (Master / detail), this would alter help in the hierarchical display.
Refer to http://msdn.microsoft.com/en-us/library/ms171913.aspx[^] for accessing related records.

3. You need a tree view control which can display multiple columns and should be able to display different columns at each level.
You can use multi level hierarchical data templates in wpf for this purpose.

If you wish to use ASP.Net you can simply use multi level nested GridView
Refer to Walkthrough: Creating a Nested GridView Control [^]

Sourav Sarkar-SS · Answer 2 · 2012-01-07T09:13:00

void fill_Tree2()
       {

           SqlConnection con = new SqlConnection();
           con.ConnectionString = Global.constr;
           con.Open();
           SqlCommand cmd2 = new SqlCommand("Select distinct station from Dealers order by station", con);
           SqlDataAdapter da = new SqlDataAdapter(cmd2);
           DataSet PrSet = new DataSet();
           da.Fill(PrSet, "Dealers");

           treeView1.Nodes.Clear();

           foreach (DataRow dr in PrSet.Tables[0].Rows)
           {

               TreeNode tnParent = new TreeNode();

               tnParent.Text = dr["Station"].ToString();

               tnParent.Tag = dr["Station"].ToString();

               //   tnParent.PopulateOnDemand = true;

               //   tnParent.ToolTip = "Click to get Child";

               //   tnParent.SelectAction = TreeNodeSelectAction.SelectExpand;

               tnParent.Expand();

               //   tnParent.Selected = true;

              treeView1.Nodes.Add(tnParent);

               FillChild(tnParent, tnParent.Tag.ToString());

           }
       }
       public void FillChild(TreeNode parent, string ParentId)
       {
           SqlConnection con = new SqlConnection();
           con.ConnectionString = Global.constr;
           con.Open();
           SqlCommand cmd2 = new SqlCommand("Select * from Dealers where Station ='" + ParentId+"'", con);
           SqlDataAdapter da = new SqlDataAdapter(cmd2);
           DataSet PDataset = new DataSet();
           da.Fill(PDataset, "Dealers");
           DataSet ds = PDataset;

           parent.Nodes.Clear();

           foreach (DataRow dr in ds.Tables[0].Rows)
           {

               TreeNode child = new TreeNode();

               child.Text = dr["Code"].ToString().Trim();

               child.Tag = dr["Code"].ToString().Trim();

               if (child.Nodes.Count == 0)
               {

                   //child.PopulateOnDemand = true;

               }

               // child.ToolTip = "Click to get Child";

               // child.SelectAction =TreeNodeSelectAction.SelectExpand;

              // child.CollapseAll();

               parent.Nodes.Add(child);

           }

       }

TreeView Control displaying Sql Table Data

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0