Recursive Treeview *resolved*

Ok, i have a database

Code:

---

ID    Department          Section          Name        OwnerID
===================================================================
1      Dep1                    Sec1      Root 1      0
2      Dep1                    Sec1      Root 2      0
3      Dep1                    Sec1      Sub 1-1    1
4      Dep1                    Sec1      Sub 2-1    2
5      Dep1                    Sec1      Sub 2-1-1  2

... etc ...

---

I have a 3 tier layout (GUI, Business, Data (linking to SQL2000)).

How would i go about creating a recursive procedure which will populate the treeview back at the GUI layer??

Im completely confused now so have given up guessing!

Any help at all will be greatly appreciated.

I helped another person with a similar problem...

Lets see if i can find the code...

Here is the post... Just adapt it a little and your set...

Thanks :) This looks like exactly what i need... i hope i can wangle it with the database and not CSV...

probably really easy but the whole recursive concept baffles me :blush: :blush: :blush:

If you need further help.... i can help you from the point the data is loaded into a dataset/datatable.

Thank you :) Worked first time (well 2nd, after i corrected MY mistakes)

You have no idea how much you have helped me!! Thank you again :D

np