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

Ajax Grid now showing data in ASP.NET MVC

10 Answers 214 Views

Grid

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

Darius asked on 09 Sep 2013, 12:40 PM

Hello there,

I am trying the simple example on the site (Ajax Grid Biding and Editing) and the Grid isn't showing me any data. I tried the server binding and it works. Below is my code.

Razor:

@(Html.Kendo().Grid<KendoTest2.Models.DocumentType>()

.Name("grid")

.DataSource(dataSource => dataSource // Configure the grid data source

.Ajax() // Specify that ajax binding is used

.Read(read => read.Action("Products_Read", "Home")) // Set the action method which will return the data in JSON format

)

.Columns(columns =>

{

// Create a column bound to the ProductID property

columns.Bound(product => product.Id);

// Create a column bound to the ProductName property

columns.Bound(product => product.Name);

// Create a column bound to the UnitsInStock property

})

.Pageable() // Enable paging

.Sortable() // Enable sorting

)

Controller:

public ActionResult Products_Read([DataSourceRequest]DataSourceRequest request)

{

using (var northwind = new MMCC_DocumentManagementEntities())

{

IQueryable<DocumentType> products = northwind.DocumentTypes;

DataSourceResult result = products.ToDataSourceResult(request);

return Json(result);

}

It's the simple example on the site, adapted on my model. That's all. Not showing data. I checked and the Json(result) returns data. What could it be the problem?

10 Answers, 1 is accepted

answered on 10 Feb 2014, 12:19 PM

Hello,
I am having exactly the same problem, and i also found out that when i turn Lazy Loading OFF, my data are showing up.
Here is a code part

In my Controller
Function Zaposleni_Read(request As DataSourceRequest) As ActionResult
            Using db As New Kontrolori_smeneEntities
                Dim result As List(Of Zaposleni) = db.Zaposlenis.ToList
                Return Json(result.ToDataSourceResult(request))
            End Using
        End Function
In my View
Html.Kendo().Grid(Of TelerikMvcApp3.Zaposleni)() _
            .Name("Grid") _
            .Columns(Sub(c)
                             c.Bound(Function(p) p.Ime)
                             c.Bound(Function(p) p.Prezime)
                     End Sub) _
        .Pageable() _
        .Sortable() _
        .Filterable() _
        .DataSource(Function(d)
                            d.Ajax().Read(Function(read) read.Action("Zaposleni_Read", "Zaposleni"))
                    End Function) _
        .Render()

Any help why is this related to Lazy Loading?