Unable to bind Asp.Net Core Grid in MVC

[Nhir]

Hi,

I am new to Telerik controls. I am trying to bind grid to datasource, not sure what am I doing wrong but grid is always empty.

Here is some sample code.

 public IActionResult Index(string YYYYQ)
        {
            var initialYYYYQ = YearAndMonth.AbstractStartYearMonth();
            SelectedMeasuresViewModel sModel = GetMeasureSelectionData(initialYYYYQ);      
            return View(sModel);
        }

 public ActionResult MeasureSelections_Read([DataSourceRequest] DataSourceRequest request)
        {
            return Json(GetMeasureSelectionData("2017-02"));
        }

private SelectedMeasuresViewModel GetMeasureSelectionData(string YYYYMM)
        {

         measureSelectionList = someData;
            SelectedMeasuresViewModel sModel = new SelectedMeasuresViewModel();
            sModel.SelectedYYYYMM = YYYYMM;
            sModel.SelectedMeasureSets = measureSelectionList; (this is list of MeasureListData)

            return sModel;
        }

 

View is simple

@using (Html.BeginForm())
{

 @Html.DropDownListFor(m => m.SelectedYYYYMM, YearAndMonth.MonthDropdownOptions(), new { onchange = "this.form.submit(); " })

@Html.Partial("MeasureSelections", Model.SelectedMeasureSets)

}

Partial View is

@(Html.Kendo().Grid<EncorI.Web.Areas.Admin.Models.MeasureListData>()
        .Name("measureSelectionGrid")
        .Columns(columns =>
        {
            columns.Bound(c => c.Enabled).Width(100);
            columns.Bound(c => c.MeasureSetID).Width(100);
            columns.Bound(c => c.MeasureSetName).Width(300);
            columns.Bound(c => c.HospitalID).Width(100);
            columns.Bound(c => c.HospitalName).Width(300);
        })
        .HtmlAttributes(new { style = "height: 850px;" })
        .Scrollable()
        .Groupable()
        .Sortable()
        .Pageable(pageable => pageable
            .Refresh(true)
            .PageSizes(true)
            .ButtonCount(5))
        .DataSource(dataSource => dataSource
            .Ajax()
            .Read(read => read.Action("MeasureSelections_Read", "measureSelectionGrid"))
            .PageSize(20)
        )
)

[Nhir]

Nm figured it out.

[Dean]

As someone now having the same problem, any chance you can actually post what the problem was?

My code is almost identical to yours, other than returning as ToDataSourceResult(request) and my grid refuses to display any rows.

 

[Dean]

In case anyone runs in to the same problem. For me it was because I hadn't added this to the startup.cs file.

services.AddMvc().AddJsonOptions(options => options.SerializerSettings.ContractResolver = new DefaultContractResolver());

The page at http://docs.telerik.com/aspnet-core/getting-started/getting-started mentions adding the call to services.AddKendo() and includes the above json in the code example but doesn't specifically say you need to add it (so I ignored it).

 

[Viktor Tachev]

Hi,

The behavior you are observing is because by default in .NET Core the fields will be serialized in camelCase. However, the Grid is looking for fields that are in PascalCase, Thus, the data is not recognized and is not displayed. This is what the setting is doing - it specifies how the data will be serialized to the client. 

For more information on this you can check out the resources below:

• http://docs.telerik.com/kendo-ui/knowledge-base/grid-is-not-showing-data
• http://docs.telerik.com/aspnet-core/getting-started/getting-started#configuration-Add

Regards,
Viktor Tachev
Progress Telerik