sankar d

sankar d

  • NA
  • 195
  • 1.8k

populate tree view

Sep 9 2012 4:09 AM
how to populate tree view from single table with parent child relation

This is my table

GrpId       GrpName        PId
*********************
1             Department       0
2             Grp1                 1                
3             Admin               2
4             Sales                2
5             Purchase           3
6             Grp2                 1
7             Finance             6
8             Production         6

I want the result as like this

Department
----Grp1
-------Admin
-------Sales
-------Purchase
----Grp2
-------Finance
-------Production

             


Answers (1)