I am using the Kendo grid in remote virtualization mode for a very large data set. My stored procedures are aware of paging and capable of returning partial data fetches, instead of returning all rows for every request. Each service call will return exactly one page worth of data (100 records) based on my start/end markers. I use the request object to calculate the appropriate offsets for the next pull.
There are several 1000 records in my total record set, so I would like to avoid pulling all the data for every request.
However, for some reason I am not able to use ToDataSourceResult to build the JSON object that the grid expects to be passed back from my virtualization action:
EX:
public ActionResult Virtualization_GetProducts([DataSourceRequest] DataSourceRequest request, int productId)
{
int startIndex = (request.Page - 1) * request.PageSize + 1;
int endIndex = startIndex + request.PageSize - 1;
var result = service.GetProducts(productId,startIndex,endIndex);
return Json(result.ToDataSourceResult(request));
}
The result that I get is {"Data":[],"Total":100,"AggregateResults":null,"Errors":null} -- even though I get back the expected result from the service.
If I instead return all the data without using startIndex/endIndex the grid is able generate the correct JSON.
All the examples I've found (including your demo) involve pulling all the data in your data source every time. Is there a way to make this work with a data source that supports its own paging like above?
There are several 1000 records in my total record set, so I would like to avoid pulling all the data for every request.
However, for some reason I am not able to use ToDataSourceResult to build the JSON object that the grid expects to be passed back from my virtualization action:
EX:
public ActionResult Virtualization_GetProducts([DataSourceRequest] DataSourceRequest request, int productId)
{
int startIndex = (request.Page - 1) * request.PageSize + 1;
int endIndex = startIndex + request.PageSize - 1;
var result = service.GetProducts(productId,startIndex,endIndex);
return Json(result.ToDataSourceResult(request));
}
The result that I get is {"Data":[],"Total":100,"AggregateResults":null,"Errors":null} -- even though I get back the expected result from the service.
If I instead return all the data without using startIndex/endIndex the grid is able generate the correct JSON.
All the examples I've found (including your demo) involve pulling all the data in your data source every time. Is there a way to make this work with a data source that supports its own paging like above?
1 Answer, 1 is accepted
0
Hello Tor,
In order to handle the data processing yourself you should not relay on ToDataSourceResult extension but create and populate the DataSourceResult instance manually. As you know the ToDataSourceResult extension method will process the data based on the request object. Thus, in your case it will try to page already paged data and will return nothing.
Please refer to this help article for more information on setting custom binding.
Regards,
Rosen
the Telerik team
In order to handle the data processing yourself you should not relay on ToDataSourceResult extension but create and populate the DataSourceResult instance manually. As you know the ToDataSourceResult extension method will process the data based on the request object. Thus, in your case it will try to page already paged data and will return nothing.
Please refer to this help article for more information on setting custom binding.
Regards,
Rosen
the Telerik team
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!