How can I implement server-side paging between web service and RadGridView?

[Alain]

How I can do server-side paging/sorting/filtering in a RadDataGrid. I retrieve the data from an azure function and I don't want to retrieve all data from the database. I pass as a parameter to the azure function, the page index, and the page size.  the response returns the result of the LINQ query with Skip(page index) and Take(page Size), and total row count.

Thank you for your help.

[Martin Ivanov]

Hello Alain,

To achieve your requirement you can implement the updates from and to the database manually. You can see the available API in the Managing Data section of RadGridView's documentation. The following list shows one way to implement your requirement.

• You can create a wrapper class for the rows in the GridView that will hold the rows information received from the server. You can assign a collection of the wrappers to the ItemsSource property of RadGridView.
• When you receive new data from the server, you can update the ItemsSource accordingly.
• When add, remove or update actions occur in the GridView, you can use the associated events and make the http requests to the server.
• For the paging, you can use the PageIndexChanged event of RadDataPager. In the event handler, you can create the http request using the PageIndex and PageSize properties of RadDataPager. And when you get the response results, you can update the ItemsSource of RadGridView.

I hope this information was useful.

Regards,
Martin Ivanov
Progress Telerik