Thanks for your interest in Syncfusion products.
We understand your requirement to load data based on the page size and current page in Grid. We can achieve this requirement using the “Load on Demand” technique of the ejDataManager. The details of the number of data to be retrieved will be obtained in skip and take parameters of the DataManager Class. Please refer to the following code example on how the data is filtered using the skip and take parameters of the DataManager Class
public ActionResult Event(DataManager dm)
IEnumerable DataSource = OrderRepository.GetAllRecords();
DataResult result = new DataResult();
DataOperations operation = new DataOperations();
result.result = DataSource;
result.count = result.result.AsQueryable().Count();
if (dm.Skip > 0)
result.result = operation.PerformSkip(result.result, dm.Skip);
if (dm.Take > 0)
result.result = operation.PerformTake(result.result, dm.Take);
return Json(result, JsonRequestBehavior.AllowGet);
Please refer the below screenshot:
We have created a sample using URL Adaptor, which can be downloaded from the below location.
Please refer to the below online documentation for more information on the adaptors.
Ragavee U S.