[Solved] Loading pages dynamically

[Jeff]

1. Is there a way to not load all the data for paging. If one has say thousands of records and 90% of the time the user will not really need to page through all of them but yet still give the ability to page, is there a sample for this scenario?I saw this one but it refreshes the whole page. I just want the grid to be refreshed.
2. On the same topic and assuming the answer is yes to bullet #1, what happens if page 1 is displayed but all the other pages have not been loaded yet and the user filters on the column that does not contain data on page 1, can it go out and grab the data based on the filter without refreshing the whole page?

Both points deal with efficiency and bandwidth and I really hope there's a solution for both. Any detailed insight, links or demos is appreciated.

[Atanas Korchev]

Hi Jeff,

 The grid never loads all pages of data if it is provided a LINQ-enabled IQueryable as a datasource. In fact in all cases only one page is requested. The grid is using LINQ expressions to page, filter, sort and group the data. If the underlying LINQ provider is Entity Framework, NHibernate, LINQ to SQL those linq expressions will be executed in the database and only a single page of data will be returned.

 The custom binding example shows how to do paging, sorting, filtering and grouping if you are not using any of the aforementioned ORMs will LINQ provider capable of translating linq expressions to SQL. We have an ajax enabled version of that example which does not refresh the whole page.

All the best,

Atanas Korchev
the Telerik team

[Jeff]

Thank you, will take a look.