Hierarchichal Grid using custom objects

[Mike Hale]

I have a class that has a property which is a collection of other objects (think Order with List<OrderDetail>). I want to populate the nested grid with the child objects (Order Detail) but I can't get to the parent object in the DetailTableBind event, and I can't find how to specify the property that contains the child data. The documentation is clear for requerying the database everytime to get the nested data, but that isn't always practical in the real world.

[Tsvetina]

Hi Mike,

You can get the DataKeyValue for the parent item and use it to fetch the correct data item from the data source like that:

object dataKeyValue = ((source as RadGrid).NamingContainer as DataItem).GetDataKeyValue("ID");
//use the dataKeyValue to fetch the correct Employee object

The above code assumes you have an Employee property named ID and you use it as the data key value for the RadGrid data item (by settings DataKeyNames="ID" in the respective GridTableView).

Also, you should wire the nested RadGrid's NeedDataSource event and bind the control there.

Additionally, you can view this forum thread, as a few possible issues connected to your scenario were discussed there.

Regards,
Tsvetina
the Telerik team