ToDatasourceResult is not working

[ShanthaKumar]

Hi team,

I am new to Kendo UI Grid, for the last two days trying to do custom pagination for kendo grid using Stored Procedure which takes care of pagination with the pageindex and pagesize as sql parameters, for which I dint see any example.

When I exactly followed the steps to do pagination(http://docs.kendoui.com/getting-started/using-kendo-with/aspnet-mvc/helpers/grid/ajax-binding)  I am getting the following error

System.Linq.IQueryable<object> doesn't contain a definition for ToDataSourceResult and no extension method for ToDataSourceResult accepting a first argument of type System.Linq.IQueryable<object>

I have already included Kendo.MVC.UI namespace in my code.

Please let me know where I am going wrong for ToDataSourceResult.

Regards
VKC

[Atanas Korchev]

Hi,

To use the ToDataSourceResult extension method you need to import the Kendo.Mvc.Extensions namespace.

Regards,
Atanas Korchev
Telerik

[Jyotish]

Hi Team,

Could you please let me know where to find Kendo.Mvc.Extensions for asp.net MVC 5 existing project as I am unable to find the same.

[Jyotish]

Got the solution, Thanks!!

[Graham]

I got the error when I applied ToDatasourceResult after applying the Json method, and not before.

[Alex Hajigeorgieva]

Hello, Graham,

Can you please provide a code snippet and a screenshot of the error? The expected syntax is as follows:

public ActionResult Orders_Read([DataSourceRequest]DataSourceRequest request)
{
    // where Orders is an IQueryable or IEnumerable
    var result = dataBase.Orders.ToDataSourceResult(request);
    return Json(result);
}

Kind Regards,
Alex Hajigeorgieva
Progress Telerik

[Graham]

Hello Alex,

 

I managed to get to the right order as shown in your post (apply ToDataSourceResult first, Json second). I posted so that next time I get the error, and my search leads me to this thread, I get the answer straight away.

 

Kind Regards,

Graham H. Laight

[Chris]

Thanks for posting.  The comment about IQueryable or IEnumerable helped me.  I confirmed that I was using an IQueryable var.