This is a migrated thread and some comments may be shown as answers.

DataSource pagesize not working

2 Answers 245 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Yasmine asked on 22 Oct 2015, 08:25 PM

When putting the grid together, running my solution in IIS express works great, however when it runs on full IIS 8, the grid returns all 23k rows of data, rather than the 25 i specified in the pagesize. Dubugging the code shows the DataSourceRequest object has 0 for the page size. Again, this is for initial page load and even if i filter. Thoughts?

Html.Kendo().Grid<TaxEx.Entities.ViewEffectiveCompanyTax>().Name("grid")
.Columns(c =>
{
c.Bound(p => p.Id);
c.Bound(p => p.EffectiveDate);
c.Bound(p => p.AppCompanyNameId);
})
.Filterable()
.DataSource(dataSource => dataSource
.Ajax()
.PageSize(25)
.Read(read => read.Action("GetData", "Company")))
.Scrollable(scrollable => scrollable.Height(600))
.Pageable()

CONTROLLER CODE:

public ActionResult GetData([DataSourceRequest]DataSourceRequest request)
{
using (TaxExEntities entity = new TaxExEntities())
{
IQueryable<ViewEffectiveCompanyTax> details = entity.ViewEffectiveCompanyTaxes;

DataSourceResult result = details.ToDataSourceResult(request, x => x);

return Json(result2);
}

}

DataSource pagesize not working

2 Answers, 1 is accepted