Show only Parents in the Self Referencing Gridview

[Ramasamy]

Hi,

I have a table like the below

ID   Name          Parent ID
1    Benefits        NULL
2    Enrolment     NULL
3    Health             1
4    Employee       1
5    Initial               2

and i need the output like

-Benefits
      - Health
      - Employee
- Enrolment
      - Initial

Now I am getting the hierachy correctly, but instead of showing only the parents my grid shows all the 5 rows. Any idea please.

Thanks,
Ramasamy

[Ramasamy]

Hi,

I have solved this issue by using the filterdescriptor

<telerik:RadGridView.FilterDescriptors>
<telerik:FilterDescriptor Member="ParentID" Operator="IsEqualTo" Value="0"/>
</telerik:RadGridView.FilterDescriptors>

It shows only the parent first and while expanding it shows the child.

Thanks,
Ramasamy