Hi,
if we set Set the AllowPaging property to True and PageSize to 10, and we executed sql (e.g.select * from table), grid has all records from database or it has only 10 records?
And if we click next page (next 10 records) grid loads records from "cache" or it loads next 10 records only from database?
if we set Set the AllowPaging property to True and PageSize to 10, and we executed sql (e.g.select * from table), grid has all records from database or it has only 10 records?
And if we click next page (next 10 records) grid loads records from "cache" or it loads next 10 records only from database?
3 Answers, 1 is accepted
0
Hello Olo,
Please examine the following links:
Data Paging in ASP.NET
Efficient Data Paging with the ASP.NET 2.0
Basic paging
Best regards,
Daniel
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
Please examine the following links:
Data Paging in ASP.NET
Efficient Data Paging with the ASP.NET 2.0
Basic paging
Best regards,
Daniel
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
0
Olo
Top achievements
Rank 1
Rank 1
answered on 26 Feb 2009, 03:40 PM
Ok, I'll read these articles, but You did not answer to my question.
I'm using radgrid and I don't know how paging works in radgrid.
Radgrid is caching all records from DB or it takes portion from all records (10 records) when I set pagesize to 10
I'm using radgrid and I don't know how paging works in radgrid.
Radgrid is caching all records from DB or it takes portion from all records (10 records) when I set pagesize to 10
0
Hello Olo,
If you set the page size to 10 and you bind RadGrid to DataSource control with 1000 records:
Note that this is a general case - I suppose you know that RadGrid will need to get all data when using Filtering, Grouping or Sorting.
Hope this clarification is useful.
Best regards,
Daniel
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
If you set the page size to 10 and you bind RadGrid to DataSource control with 1000 records:
- - using LinqDataSource or EntityDataSource: RadGrid will fetch only 10 records
- - using any data source and custom paging: this depends on your approach
- - using build-in paging with datasource other than the aforementioned (LDS and EDS): RadGrid will take 10 items from the data, provided by your data source.
Note that this is a general case - I suppose you know that RadGrid will need to get all data when using Filtering, Grouping or Sorting.
Hope this clarification is useful.
Best regards,
Daniel
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.