How to populate a Windows Form treeview from a SQL 2005 table?

Question

I am very new to C#.  I need to create a Windows Form that will read a SQL 2005 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 not found a Windows Forms C# example that can handle an un specified level of node nesting and Parent = Child see child rows 15.

 

I would really appreciate the help.

 

Thank you.

 

 

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

Child...Parent...Depth.....Hierarchy
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