How Do I Create A Report For Mlm Application

See more:

ASP.NET

SQL-Server

hi ,

i m doing MLM based Appication, i need to show the Report For the Agents
For example:


if i am going to look the Team Level For Id=38

Tbl_advisor

id  agentId ParentId
1    38      37
2    56      38
3    57      38
4    58      38

5    60      56
6    61      56
7    62      57
8    63      58
9    65      58
10   66      58

11   67      60
12   68      61
13   69      61
14   70      62
15   71      63
16   73      63

....

this is ma report Format.
i have tried this by GridView ,But i couln't Get the Records Frequently.

can any one give me some reference to do this.

Thanks,
King_Fisher.