NeedDataSource fires on next page

[Michael]

When I push the next page plik on a RadGrid the NeedDataSource event fires.  How do I get the grid to handle paging without hitting the database each time?

<telerik:RadGrid
        ID="RadGrid1"
        runat="server"
        Width="100%"
        Height="100%"
        GridLines="None"
        AutoGenerateColumns="False"
        AllowSorting="True"
        AllowFilteringByColumn="True"
        SelectedItemStyle-BackColor="LightBlue" AllowPaging="True"
        onneeddatasource="RadGrid1_NeedDataSource" PageSize="100">

[Pavlina]

Hello Michael,

When RadGrid current page is changed, sort, filter or insert/update/delete operations are performed, RadGrid is being implicitly rebound. You can find more information on the RadGrid lifecycle in the below articles:

http://www.telerik.com/help/aspnet-ajax/grdeventsequence.html
http://www.telerik.com/help/aspnet-ajax/grdcommandsthatinvokerebindimplicitly.html

Best wishes,
Pavlina
the Telerik team

[Michael]

Even though I queried the data source and got all the records (say 1000) and my page size is set to 100 in the grid.  When the user hits the page button,I have to go back to the database for the data again?

[Pavlina]

Hi Michael,

I am sending you a simple working project which handles the desired functionality. Please give it a try and let me know if it works for you.

Best wishes,
Pavlina
the Telerik team

[Michael]

Pavlina;
Thank you for your help.  That was just what I wanted!