Ok, i have a database
I have a 3 tier layout (GUI, Business, Data (linking to SQL2000)).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 ...
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.




Reply With Quote