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
300
Paging using AJAX
posted

Is there any way to wire up the grid to do AJAX paging, just get the data as needed.  There are some situations where my search results can be very large so I would like to only load the rows that i need into the grid instead of setting the grid to the entire datasource.  I know i could handle this through a custom pager, but i wanted to check if there was something built in that would allow me to accomplish this. 

an example. 

search returns 1000 records.  pager is set to show only 50 at time so my ajax only pulls the first 50.  if they click on page 2 i get the next 50 through ajax call, etc.  I do understand that this would do away with any local sorting or filtering, just trying to think of more creative ways to load the data and make it faster on the client side in case of a larger result set.

Thanks,

Sy

 

  • 24671
    posted

    Hi,

    not sure if i understand correctly the question. Any of the features - paging, sorting, filtering, can be either local or remote (out of the box). So if you set the type: "local" off the Paging feature, it will do local paging.

    If you want paging to be remote, there are several ways to do it:

    1) using the MVC wrapper, then all URL encoding, etc. is done for you, including the data binding on the server, which is done through LINQ, so only the necessary records are selected from the data source not all

    2) Using OData, in that case the URL encoding follows OData conventions

    3) using custom url encoding, in that case you need to set the pageIndexUrlKey, and the pageSizeUrlKey, as described here:

    http://help.infragistics.com/jQuery/2011.1/ui.iggridpaging#!options

    Then in your service, you need to interpret those URL params, and return the data based on them.

    Let me know if i can help you further, in case you can provide some more details about the scenario.

    Thanks !

    Angel