About paging

[Robert Lou]

I learn that the paging method about rad.grid is load all the data to memory, so we found that just 100 thousands rows records slow server very much.we major in ERP system, and the database records often reach 10 millions and more. so the paging way provide by rad.grid will not adapt to the requirement. Does rad.grid provide the way which get just records of one page one time? It is, we can use the paging way　provided by database such as ROW_NUMBER in sql server 2005. so the grid will load only one page records from the server and will not load all the records to dataset at first.

[Iana Tsolova]

Hi Robert,

To achieve your goal, you can either implement custom paging, or bind your RadGrid with LinqDataSource/EntityDataSource which support paging themselves.

Find more infotmation below:
http://demos.telerik.com/aspnet-ajax/grid/examples/programming/custompaging/defaultcs.aspx
http://demos.telerik.com/aspnet-ajax/grid/examples/databinding/net35datasourcecontrols/defaultcs.aspx

Kind regards,
Iana
the Telerik team

[Robert Lou]

Thanks.