The behavior you describe is not directly related to RadGrid
. This is a functionality provided by the DataSource control. For example if you use SqlDataSource Control it will retrieve all records from the database and pass them to the grid. Then RadGrid will page the items internally.
On the other hand the EntityDataSource
provides more advanced query mechanisms. It can retrieve only the items that will be displayed. This should considerably improve performance. You can check that in action in the following online example.
If you bind RadGrid in the code-behind you would need to implement Custom Paging. You would need to use additional logic to request only the relevant items from the database and pass them to the Grid. The demo below outlines the approach you can use to implement the behavior.
Telerik by Progress
Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer
and share your thoughts.