[Solved] Self-referencing gridview

[Mahmut]

 

Hi,
I have a table with hierarchical structure (table fields: CustomerGuid(rowguid),....,ParentGuid(nullable)).
I'm trying to use self-referencing gridview to show this data by using the xaml lines below.

<telerik:RadGridView.ChildTableDefinitions> 

<telerik:GridViewTableDefinition>

<telerik:GridViewTableDefinition.Relation>

<telerikData:TableRelation IsSelfReference="True">

 <telerikData:TableRelation.FieldNames>

<telerikData:FieldDescriptorNamePair

ParentFieldDescriptorName="CustomerGuid" 

ChildFieldDescriptorName="ParentGuid"/>  

</telerikData:TableRelation.FieldNames>  

</telerikData:TableRelation>  

</telerik:GridViewTableDefinition.Relation>  

</telerik:GridViewTableDefinition>  

</telerik:RadGridView.ChildTableDefinitions>

This pattern works well. But I want rows (or entities) with ParentGuid to be shown only in child table (not more than once). Is it possible?
Thanks in advance...

 

 

 

 

[Dimitrina]

Hello Mahmut,

You can easily prevent such rows(with ParentID != 0) from appearing on the root level by creating a filter descriptor which would only allow rows with ParentID equal to 0.

Copy Code

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

May you please refer to this forum thread on the same topic?

Greetings,
Didie
the Telerik team

[Mahmut]

Hello Didie,

It's OK.
Thank you very much for your quick reply.

Best wishes...
Mahmut