Support ID:664435 -- Loading grid data on demand

[Ashish]

Hello,

We had created a support ticket - 664435.

We have posted this,

Currently, we need  Telerik grid to allow data loding on demand. i.e we have huge data set that we are trying to assign to grid but then we get 'MaxJSONLength' error. The telerik grid allows to do custom paging by setting VirtualItemCount but then the data fetching has to be handled by the user. Also, the sorting and filtering can not work as we bind only current page data to the grid. We need support so that we can bind data on demand to the telerik grid and it should be able to work with sorting and filtering.

We got reply as below,

Currently the RadGrid provides virtual scrolling mechanism which could properly work with paging and sorting and not a clean built in load on demand. See the online demo below for more information on this matter:
http://demos.telerik.com/aspnet-ajax/grid/examples/client/virtualscrollpaging/defaultcs.aspx

But if you check above link, sorting is working on just current page's data and not on Entire dataset.  So is it possible that sorting and filtering work for entire data, along with facility of loading grid data on demand?

[Maria Ilieva]

Hi Ashish,

Please note that the required functionality is not supported with none of the DataBind controls and respectively with the RadGrid.
It is not possible to have data load on demand in the Grid and at the same time sort and filter the whole data set. The only possible approach is to firstly get the RadGrid sort and filter expressions, apply them to the whole DataBase manually and retrieve only the sorted and filtered data to the RadGrid.This however will decrease the performance significantly and will make the usage of the load on demand approach pointless.

Regards,
Maria Ilieva
the Telerik team

[Margret]

Hi All,
I have 17000 records to be populated with the radgrid.It takes more than one minute.so,in pageload event , it has to load only 10 records and then when clicking on the page buttons,it will load other data according to the page index and page size like load data on demand concept with pagination.can anybody help on this?

[Princy]

Hi Margret,

I guess you want to show only 10 records first then while scrolling down the rest of the records.
Please have a look at this demo on Grid - Virtual Scrolling and Paging.


Thanks,
Princy

[Margret]

Thanks princy.

                  Is it possible to load data on demand using pagination as like in ordinary asp grid controls? .It doesnot use any ajax and scrolling things.Initially it will load only 10 records.And if the records is more than 10,it will have paging control and display records based on the page index  and page size.Please update me for the same.Can i do the load data on demand in grid, only based on the paging in grid?


Thanks in advance
Margret

[Margret]

Hi All,
Any update on this scenerio?

[Princy]

Hi Margret,

You can implement RadGrid with custom paging to achieve your goal.
Please check out the below documentation for more information.
Custom Paging.

Let me know if further questions arise.

Thanks,
Princy

[Margret]

Thanks Princy.
I have tried using the Virtual item count in the given example.It is loaded the data on demand in the grid, correctly .

[Margret]

Hi All,
Iwant to do sorting with the load data on demand in telerik grid.For that ,what are all the steps i could follow?.Custom paging example ,I cant get the logic.If i set the Allow sorting =true, then the paging is not met my reqiurement.In first page,I didnt have any record,while clicking the other column header text for sorting.Please let me know the steps,if anybody know.

[Margret]

I think, have to set " AllowMulticolumnSorting=true" in master table view for the above scenario.

[Margret]

Hi ,any update on this?

[Maria Ilieva]

Hello Margret,

Setting "AllowMulticolumnSorting=true" should properly work with custom paging scenarios. What are the exact issues you are currently facing? Provide some more information on your exact implementation and the issues you are facing so that we could further research on your case and provide proper solution.

Regards,
Maria Ilieva
Telerik