Grid with custom paging and custom filtering and custom grouping

[Tomer]

Hi,

We are working with the rad grid and we till now we are binding the data in a basic binding for historical reasons.
Now we want to change the behavior of the data binding, filtering and grouping to gain the best performance we can get from your grid.

We work with ado.net and mssql, and I wanted to know if there is an example for our needs that I can learn from it.
I don't care if it a client binding or server binding. but I need a paging and filtering and grouping that I will send the expression
(paging: startIndex,page size and so, filtering: expression and grouping: I don't how it's works behind the scene) to our stored procedure
and than I will get the results of the only page size.

10x.

[Viktor Tachev]

Hello Tomer,

In case you would like to retrieve only the records that will be shown on the current page in RadGrid you can use the approach illustrated in the live demo below:

• RadGrid Custom Paging

If you prefer to use client-side binding you can use RadClientDataSource control. You can also pass additional parameters to the service using the OnCustomParameter handler. Check out the following online demo that showcases how you can bind RadGrid to a RadClientDataSource control.

• RadGrid - Binding to Telerik ClientDataSource

Regards,
Viktor Tachev
Telerik