TreeView (please help)

treeview problem

person office department company

Vera arbeiders H&R Cambells
Marc IS MIS Capsugel
Pieter IS MIS Capsugel
Bart IT MIS Capsugel
Frank ploeg A prod Capsugel

I need to get this table (datatable from a dataset) in a TreeView control and I can 't figure it out to get it done correctly.

I shoul look like this:

Cambells
------------H&R
-------------------arbeiders
-------------------------------Vera
Capsugel
--------------IS
------------------MIS
-----------------------Marc
-----------------------Pieter
------------------IT
-----------------------Bart
--------------prod
------------------ploeg A
-------------------------Frank


Can somebody pease help me ?

Here is some code to hard-code it in the treeview, to get it from a database, just use some simple SQL and some looping mechanisms:

VB Code:

Dim myNode As TreeNode
        Dim mynode2 As TreeNode
        myNode = TreeView1.Nodes.Add("Campbells")
        myNode = myNode.Nodes.Add("HR")
        myNode = myNode.Nodes.Add("arbeiders")
        myNode = myNode.Nodes.Add("Vera")
        myNode = TreeView1.Nodes.Add("Capsugel")
        mynode2 = myNode.Nodes.Add("IS")
        mynode2 = mynode2.Nodes.Add("MIS")
        mynode2.Nodes.Add("Marc")
        mynode2.Nodes.Add("Pieter")
        mynode2 = mynode2.Parent.Nodes.Add("IT")
        mynode2.Nodes.Add("Bart")
        mynode2 = myNode.Nodes.Add("Prod")
        mynode2 = mynode2.Nodes.Add("ploeg A")
        mynode2.Nodes.Add("Frank")