Thank you for writing.
When using paging RadGridView
still needs the whole data source in order to calculate the necessary information e.g. how many pages you need. In order to improve performance you can use Virtual mode
instead. However, it does not support paging.
Load on demand
functionality is available for populating hierarchical grid. However, it is a reasonable request to have it for pages. I have logged it in our feedback portal
. You can track its progress, subscribe for status changes and add your vote/comment to it on the following link - feedback item
I have also updated your Telerik points
You can construct a UserControl
with several buttons indicating the page number. When a certain button is clicked you can repopulate the RadGridView
with the relevant subset of data.
As to your second question it seems that you need pinned columns. Please refer to our Pinning and Unpinning Columns
I hope this information helps. Should you have further questions, I would be glad to help.