Re: How to populate a treeview from a dataset

You can't directly bind a data source to a tree view. The reason for this is that most data sources deal with vectors, not heiarchical data sets.

It looks like you are getting the result set ordered by Parent, then Child, which is good.

What I would do is cycle through this set, and create a new tree view node with the child id. As you created nodes, place them in a dictionary with their ids as a key. Then, when you create a child node, get the parent node (which you have the key for) from the dictionary, and add the child to it.


--
- Nicholas Paldino [.NET/C# MVP]
- mvp@xxxxxxxxxxxxxxxxxxxxxxxxxxx

<xmail123@xxxxxxxxx> wrote in message news:471513c1.10335203@xxxxxxxxxxxx
How to populate a treeview from a dataset

I am very new to C#. I need to create a Windows form that will read a
SQL table and populate a treeview. I can connect to the DB, create
the dataadapter, populate a data set. The problem is how to use the
dataset to populate a treeview.

I have looked at a few examples here but none use a dataset, or the
data structure was different and I could not modify to work with my
data or the examples were more than I needed and too complex for a
beginner. Can some one suggest a URL, book or show me an example of
code that simply takes the data as shown and populates a treeview.

I would really appreciate the help.

Thank you.


I have a SQL Server 2005 table containing this data shown below.

Child Parent depth Hierachy
1 NULL 0 01
2 1 1 01.02
5 2 2 01.02.05
6 2 2 01.02.06
3 1 1 01.03
7 3 2 01.03.07
11 7 3 01.03.07.11
14 11 4 01.03.07.11.14
12 7 3 01.03.07.12
13 7 3 01.03.07.13
8 3 2 01.03.08
9 3 2 01.03.09
4 1 1 01.04
10 4 2 01.04.10
15 NULL 0 15
15 15 1 15.15
16 15 1 15.16
18 16 2 15.16.18
17 15 1 15.17


.

Relevant Pages

  • Re: How to populate a treeview from a dataset
    ... If it is then check to see if the parentId and child id of the ... 15 is a parent and a child of itself. ... And that same business is the headquarters for the purchasing group. ... 15 Null - root tree node, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: How to populate a treeview from a dataset
    ... If it is then check to see if the parentId and child id of the ... 15 is a parent and a child of itself. ... And that same business is the headquarters for the purchasing group. ... 15 Null - root tree node, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: CPropertySheet - dynamic pages in wizard mode
    ... Another method that I considered using was a Tree or List / splitter / child ... 'Tabs' to show however decided against it as while it would have been ... Wizard does the Create of the xxx ojbect type. ...
    (microsoft.public.vc.mfc)
  • RE: Adding Child Nodes to Treeview
    ... you can determine if the current node number is odd ... So to get to the "parent" node (child of human/animal parent) you would use ... This is considered a binary tree. ...
    (microsoft.public.access.modulesdaovba)
  • Re: How to populate a treeview from a dataset
    ... Step through this temp table. ... Child, which is good. ... SQL table and populate a treeview. ...
    (microsoft.public.dotnet.languages.csharp)