Recursive Treeview *resolved*

[carl_mathews200]

Ok, i have a database

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.

[<ABX]

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...

[carl_mathews200]

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

[<ABX]

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

[carl_mathews200]

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

[<ABX]

np