Custom paging with radgrid

[balamurugan]

Hi guys,

I was asked to bind around 1 lakh records to radgrid . but it will create some client side problem so i planned to bring first 100 records from sql db and bind it grid in terms of 10 in each page (10*10) , if user clicks eleventh page, i would like to bring another 100 records from sql and bind it to another page..

is this possible in radgrid?

or do i need to make db calls whenever next page gets clicked ? i want to reduce db calls as well.. How this can be achieved in radgrid..

Any sample much appreciated.

Thanks in advance

[Konstantin Dikov]

Hi,

There is no built-in functionality that will allow you to achieve such behavior. When custom paging is used, the paging mechanism and the way that the correct data is provided to the grid is the developer's responsibility. 

The only thing that I could suggest is that you follow the principals from our help article for custom paging (RadGrid - Custom Paging) and implement custom logic for retrieving only 100 items at a time and depending on the current page, provide those 10 items that correspond to that page. You can store the 100 items that you have retrieved in a Session variable for example and make a new query only when you need other items.

Hope this helps.


Regards,
Konstantin Dikov
Telerik