table Comments
CommentsID CommentsText CommentsRoot
1000 "Some text" Null
1001 "Some text" 1000
1002 "Some text" 1000
1003 "Some text" Null
1004 "Some text" 1003
Hi, I'm working in a proyect on VB, where I have a Nested Radgrid, it takes the DataSource from a table called Comments in SQL Server as in the top table and I would like to to have the number of child that the Comment have
For example:
The format will be like this(whith the number of child):
1000 "Some text" Null (2)
1001 "Some text" 1000
1002 "Some text" 1000
1003 "Some text" Null (1)
1004 "Some text" 1003
I have alredy this format but I don't know how to get the number of child, Can anyone help me, please?
CommentsID CommentsText CommentsRoot
1000 "Some text" Null
1001 "Some text" 1000
1002 "Some text" 1000
1003 "Some text" Null
1004 "Some text" 1003
Hi, I'm working in a proyect on VB, where I have a Nested Radgrid, it takes the DataSource from a table called Comments in SQL Server as in the top table and I would like to to have the number of child that the Comment have
For example:
The format will be like this(whith the number of child):
1000 "Some text" Null (2)
1001 "Some text" 1000
1002 "Some text" 1000
1003 "Some text" Null (1)
1004 "Some text" 1003
I have alredy this format but I don't know how to get the number of child, Can anyone help me, please?