How to use a bit field as a Parent Table Relation Key.

[Pierre]

Hi, I have a nested grid.
I need to pass my bitfield as a key in the Parent Table Relation Key.
Like :

 <ParentTableRelation>
 <telerik:GridRelationFields DetailKeyField="MSE_PK" MasterKeyField="MSE_PK" />
 <telerik:GridRelationFields
   DetailKeyField="(MST_BitField & MSE_myBit)"
        MasterKeyField="MSE_myBit" />
 </ParentTableRelation>

I need a way to to Something like this is my 'DetailKeyField' .

 

[Viktor Tachev]

Hi Pierre,

The DetailKeyField property should point the filed in the detail table that should be equal to the foreign key column in the table. Check out the following resources that describe how you can configure the hierarchy relations for the grid.

• http://demos.telerik.com/aspnet-ajax/grid/examples/hierarchy/declarative-relations/defaultcs.aspx
• http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/hierarchical-grid-types-and-load-modes/hierarchical-data-binding-using-declarative-relations

If you would like to use more complex logic for the detail tables you can define the hierarchy relations programmatically as illustrated below:

• http://demos.telerik.com/aspnet-ajax/grid/examples/data-binding/programmatic-hierarchy/defaultcs.aspx
• http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/hierarchical-grid-types-and-load-modes/hierarchical-data-binding-using-detailtabledatabind-event

Regards,
Viktor Tachev
Telerik by Progress