Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
435
manual set TotalRecordsCount with Load-on-Demand
posted

I am evaluating the Grid to see if it doable for our project at Boeing.

Due to the large amount of data (500K) rows, we want the ability to do Server side (SQL paging) for the better responsive. I am able to binding the result to Grid, and able to do Filtering and Sorting. However, I cannot get the Load-on-Demand to work because of the TotalRecordsCount doesn't seem to set. Here is what I am doing:

1. issue SQL to get total of rows

2. issue SQL to get the Next 10 records based on current Page and PageSize

3. set the TotalRecordsCount

However, the grid only show 10 records, I cannot get the Load on demand issue the request back to the server.

Please help.

Thank you

  • 23953
    Offline posted

    Hello Phong Nguyen,

    I'm following to see whether you were able to resolve your issue?

    Let me know if you have any questions.

    Best regards,
    Martin Pavlov
    Infragistics, Inc.

  • 23953
    Offline posted

    Hello Phong Nguyen,

    If you're using Grid MVC Helper wrapper and passing IQqueryable data source then it will take care of setting the correct value for TotalRecordsCount.

    If you want to handle all the paging logic by yourself here is a thread that you can read which contains a sample demonstrating custom remote paging implementation.

    Hope this helps,
    Martin Pavlov
    Infragistics, Inc.