Error while binding Kendo ui Grid using Stored Procedure

[Manikandan]

Hi Team,

I am unable to bind Kendo ui grid from stored procedure using entity framework and I am able to bind kendo ui from table using entity framework.
PFB Code for bind

from table:

return tsmsent.TSMSDets
              .OrderBy(tsms => tsms.Task)
              .Select(tsms => new TimeSheetDetails
              {
                  Task = tsms.Task,
                  Day1 = tsms.Day1,
                  Day2 = tsms.Day2,
                  Day3 = tsms.Day3,
                  Day4 = tsms.Day4,
                  Day5 = tsms.Day5,
                  Day6 = tsms.Day6,
                  Day7 = tsms.Day7
              }).ToDataSourceResult(request.Take, request.Skip, request.Sort, request.Filter);

From Stored procedure:

return tsmsent.GetTimeSheet()
    .OrderBy(tsms => tsms.Task)
    .Select(tsms => new TimeSheetDetails
    {
        Task = tsms.Task,
        Day1 = tsms.Day1,
        Day2 = tsms.Day2,
        Day3 = tsms.Day3,
        Day4 = tsms.Day4,
        Day5 = tsms.Day5,
        Day6 = tsms.Day6,
        Day7 = tsms.Day7
    })
    .AsQueryable().ToDataSourceResult(request.Take, request.Skip, request.Sort, request.Filter);

kindly help me how to get this done using stored procedure.
thanks for advance.

Regards,
Mani

[Alexander Popov]

Hello Mani,

I would recommend checking this Code Library project, where similar scenario is illustrated.

Regards,
Alexander Popov
Telerik

 

 

[rj]

i am binding kendo grid using ajax way using stored procedure. first time it will display results properly. but when i am clicking on next page or sorting i am getting below error

Query cannot be enumerated more than once.can you help me

regards,

[Genady Sergeev]

Hi Rajeshwari,

In order to have the grid working with paging in AJAX binding you have to follow the approach shown in the following demo. If this grid still fails please verify that applying Skip and Take functions to the IQueryable instance of your model is working.

Regards,
Genady Sergeev
Telerik by Progress