Loading Nested Grid Rows

[John]

Hi,

I got a hierachy nested grid with a parent row, which have two nested expaned rows. During testing, I loaded 50 records to be binded to the parent row. I see that it binded all 50 parent records first. Afterwards, it starts calling the selecting method to get each of the 50 child records to bind the nested row. I have a following code and checekd the ObjectDataSourceSelectingEventArgs parameter but could not find a record index field on which parent record it is seeking to retrieve the record for binding to the grid. I noticed that for the nested row or the inner record, it calls the selecting and then it call the GetData(string sortColumns, int startRecord, int maxRecords) method for each of the 50 parent record.

Also, how can I pass around in the markup page, the UID that is the primary - foreign table key as the datakeynames. When the child record is called on the selecting method, maybe I can get the datakeyname value to do the fetch.

 

 

protected void Response_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)

 

{

 

 

int test = 0;

 

}

Why am I asking this question> ? The grid is loading for the first time, I need to know which child record is being requested for binding under the parent row. When I get the index, I will do another fetch from the IQueryable object to return a list object.

Any help is appreciated...

[Antonio Stoilkov]

Hello John,

In order to achieve your scenario you could loop through all the RadGrid child GridTableView controls and access the parent id in the Page PreRender event where the filtering of IQueryable could be executed. Note that in the Selecting event there is no way to access which is the parent id. You could go through the help article below to observe how to retrieve the primery key values.

• Extracting primary key value for parent item in hierarchy on update/insert

Kind regards,
Antonio Stoilkov
the Telerik team