This is a migrated thread and some comments may be shown as answers.

About paging

2 Answers 53 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Robert Lou
Top achievements
Rank 1
Robert Lou asked on 27 Sep 2010, 03:21 AM
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.

2 Answers, 1 is accepted

Sort by
0
Iana Tsolova
Telerik team
answered on 29 Sep 2010, 06:06 AM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
Robert Lou
Top achievements
Rank 1
answered on 29 Sep 2010, 07:37 AM
Thanks.
Tags
Grid
Asked by
Robert Lou
Top achievements
Rank 1
Answers by
Iana Tsolova
Telerik team
Robert Lou
Top achievements
Rank 1
Share this question
or