Hello Vasya,

Thank you for getting back to me.

Yes, I did follow the Load On Demand Example.

Here is what I am trying to do. Our database has over Million records. We want to take the advantage of SQL Server paging and Load On Demand, so we get the Total Count, then the first 10 records to display. Everything is working so far.
However, I have a requirement to display data in Hierarchy, a Parent record would have two or more GridColumnLayoutModels.

I attached the code sample. Please help

Yes, I will start a new thread next time. The reason I appended to this thread because the feature I need is related to this solution pattern.

Anyway, based on the example I provided. I am looking for a way to get the Selected Row so I can get the data to Query the data for Children grids.

Currently, I have to do:

1. Get the Primary Key of the Parent Row

2. Query the Parent data based on the Primary Key

3. Query the Child data based on the Parent data

You can see there is a lot of step if I have another nested Grid in a Child grid. So I am looking for the way get the Selected Row of the expanding row.

This is another important feature that I need to complete the requirement.

Thank you very much

Hello Phong,

I am glad that you find my suggestion helpful.

What I can suggest for achieving your requirement is using GetChildren method. This method parameters will give you enough information to determine which is the current ProductID, respectively which parent row invoked the GetChilden method. Layout parameter contains information about the current layout. Based on these two parameters you could filter your data in order to retrieve only the rows needed for the corresponding child. For example if I am trying to expand first row, Adjustable Race 0, GetChild method will be called with ajaxUpdateTarger="Histories", path: ProductID: 0,layout="Histroies". You could check which layout triggered the event and filter data accordingly and add it to the WrappedGridresponse.

public JsonResult GetChildren(string ajaxUpdateTarget, string path, string layout)
        {
            if (ajaxUpdateTarget == "History")
            {
               //filter your data according to the path and layout and add filtered data to the response
 
                WrappedGridResponse response;
                response = new WrappedGridResponse(histories, null);
                return Json(response, JsonRequestBehavior.AllowGet);
            }
            else
            {
 
               //filter your data according to the path and layout and add filtered data to the response
 
                gridModel.DataSource = something.AsQueryable();
                WrappedGridResponse response;
                response = new WrappedGridResponse(something, null);
                return Json(response, JsonRequestBehavior.AllowGet);
            }
        }
 

I hope you find this information helpful.

Please let me know if you need any further assistance with this matter.

Hi Vasya,

The problem is ProductID information is not enough for me to get the Related Information of the Children. This is what I am trying to do:

1. From the expanding row, get the ProductId, ProductName, and other information. I don't want to go to the database to get the Product based on ProductId. This is not efficient because I have many nested Grids per Product.

2. Filter the Children data with (ProductId, ProductName, and other information)

3. Bind the result to the response

Please help. Thank you

Hello Phong,

I am currently looking into this matter for you. I will get back to you soon with more information or questions for you.

Thank you.

I am need have to solution ASAP.

Thanks again for looking into it.