After spending entire morning trying to get some data to be data displayed in Kendo grid I am getting pretty annoyed.
With this html (generated by Kendo MVC wrapper):
And the result of the call to the controller:
I don't get anything.
The controller does get called and the content is transfered (see atached image). But nothing is showing up.
I have no idea how to determine what could be wrong!!!!
Here is the controller method:
With this html (generated by Kendo MVC wrapper):
<
div
class
=
"k-widget k-grid"
id
=
"grid_AitTodaySectionEntity"
><
table
><
colgroup
><
col
/><
col
/><
col
/><
col
/><
col
/><
col
/><
col
/></
colgroup
><
thead
class
=
"k-grid-header"
><
tr
><
th
class
=
"k-header k-filterable"
data-field
=
"Caption"
data-title
=
"Caption"
scope
=
"col"
><
a
class
=
"k-grid-filter"
><
span
class
=
"k-icon k-filter"
></
span
></
a
><
a
class
=
"k-link"
href
=
"/Grid/Get?Type=AitTodaySectionEntity&grid_AitTodaySectionEntity-sort=Caption-asc"
>Caption</
a
></
th
><
th
class
=
"k-header k-filterable"
data-field
=
"DefaultRows"
data-title
=
"Default Rows"
scope
=
"col"
><
a
class
=
"k-grid-filter"
><
span
class
=
"k-icon k-filter"
></
span
></
a
><
a
class
=
"k-link"
href
=
"/Grid/Get?Type=AitTodaySectionEntity&grid_AitTodaySectionEntity-sort=DefaultRows-asc"
>Default Rows</
a
></
th
><
th
class
=
"k-header k-filterable"
data-field
=
"Id"
data-title
=
"Id"
scope
=
"col"
><
a
class
=
"k-grid-filter"
><
span
class
=
"k-icon k-filter"
></
span
></
a
><
a
class
=
"k-link"
href
=
"/Grid/Get?Type=AitTodaySectionEntity&grid_AitTodaySectionEntity-sort=Id-asc"
>Id</
a
></
th
><
th
class
=
"k-header k-filterable"
data-field
=
"ModuleId"
data-title
=
"Module Id"
scope
=
"col"
><
a
class
=
"k-grid-filter"
><
span
class
=
"k-icon k-filter"
></
span
></
a
><
a
class
=
"k-link"
href
=
"/Grid/Get?Type=AitTodaySectionEntity&grid_AitTodaySectionEntity-sort=ModuleId-asc"
>Module Id</
a
></
th
><
th
class
=
"k-header k-filterable"
data-field
=
"TodaySection"
data-title
=
"Today Section"
scope
=
"col"
><
a
class
=
"k-grid-filter"
><
span
class
=
"k-icon k-filter"
></
span
></
a
><
a
class
=
"k-link"
href
=
"/Grid/Get?Type=AitTodaySectionEntity&grid_AitTodaySectionEntity-sort=TodaySection-asc"
>Today Section</
a
></
th
><
th
class
=
"k-header k-filterable"
data-field
=
"IsNew"
data-title
=
"Is New"
scope
=
"col"
><
a
class
=
"k-grid-filter"
><
span
class
=
"k-icon k-filter"
></
span
></
a
><
a
class
=
"k-link"
href
=
"/Grid/Get?Type=AitTodaySectionEntity&grid_AitTodaySectionEntity-sort=IsNew-asc"
>Is New</
a
></
th
><
th
class
=
"k-header k-filterable"
data-field
=
"IsDirty"
data-title
=
"Is Dirty"
scope
=
"col"
><
a
class
=
"k-grid-filter"
><
span
class
=
"k-icon k-filter"
></
span
></
a
><
a
class
=
"k-link"
href
=
"/Grid/Get?Type=AitTodaySectionEntity&grid_AitTodaySectionEntity-sort=IsDirty-asc"
>Is Dirty</
a
></
th
></
tr
></
thead
><
tbody
><
tr
class
=
"t-no-data"
><
td
colspan
=
"7"
></
td
></
tr
></
tbody
></
table
><
div
class
=
"k-pager-wrap k-grid-pager"
><
a
class
=
"k-link k-state-disabled"
data-page
=
"1"
href
=
"#"
title
=
"Go to the first page"
><
span
class
=
"k-icon k-i-seek-w"
>seek-w</
span
></
a
><
a
class
=
"k-link k-state-disabled"
data-page
=
"0"
href
=
"#"
title
=
"Go to the previous page"
><
span
class
=
"k-icon k-i-arrow-w"
>arrow-w</
span
></
a
><
ul
class
=
"k-pager-numbers k-reset"
><
li
><
span
class
=
"k-state-selected"
data-page
=
"1"
>1</
span
></
li
></
ul
><
a
class
=
"k-link k-state-disabled"
data-page
=
"2"
href
=
"#"
title
=
"Go to the next page"
><
span
class
=
"k-icon k-i-arrow-e"
>arrow-e</
span
></
a
><
a
class
=
"k-link k-state-disabled"
data-page
=
"1"
href
=
"#"
title
=
"Go to the last page"
><
span
class
=
"k-icon k-i-seek-e"
>seek-e</
span
></
a
><
span
class
=
"k-pager-info k-label"
>No items to display</
span
></
div
></
div
><
script
>
jQuery(function(){jQuery("#grid_AitTodaySectionEntity").kendoGrid({"columns":[{"title":"Caption","field":"Caption","filterable":{},"encoded":true},{"title":"Default Rows","field":"DefaultRows","filterable":{},"encoded":true},{"title":"Id","field":"Id","filterable":{},"encoded":true},{"title":"Module Id","field":"ModuleId","filterable":{},"encoded":true},{"title":"Today Section","field":"TodaySection","filterable":{},"encoded":true},{"title":"Is New","field":"IsNew","filterable":{},"encoded":true},{"title":"Is Dirty","field":"IsDirty","filterable":{},"encoded":true}],"pageable":{"buttonCount":10},"sortable":true,"filterable":true,"scrollable":false,"dataSource":{"transport":{"prefix":"","read":{"url":"/Grid/Get?Type=AitTodaySectionEntity"}},"pageSize":10,"page":1,"total":0,"serverPaging":true,"serverSorting":true,"serverFiltering":true,"serverGrouping":true,"serverAggregates":true,"type":"aspnetmvc-ajax","filter":[],"schema":{"data":"Data","total":"Total","errors":"Errors","model":{"fields":{"Caption":{"type":"string"},"DefaultRows":{"type":"number","defaultValue":null},"Id":{"type":"number"},"ModuleId":{"type":"number"},"TodaySection":{"type":"string"},"ModModule":{"type":"object"},"Fields":{"type":"object"},"IsNew":{"type":"boolean"},"IsDirty":{"type":"boolean"},"ActiveContext":{"type":"object"},"ConcurrencyPredicateFactoryToUse":{"type":"object"},"AuthorizerToUse":{"type":"object"},"AuditorToUse":{"type":"object"},"Validator":{"type":"object"}}}}}});});
</
script
>
And the result of the call to the controller:
{
"$id": "1",
"Data": [
{
"$id": "2",
"Caption": "Calendar",
"DefaultRows": 5,
"Id": 1,
"ModuleId": 9,
"TodaySection": "CALENDER"
},
{
"$id": "3",
"Caption": "Repairs",
"DefaultRows": 999,
"Id": 2,
"ModuleId": 2,
"TodaySection": "EXP_REPAIRS"
},
{
"$id": "4",
"Caption": "Maintenance",
"DefaultRows": 999,
"Id": 3,
"ModuleId": 2,
"TodaySection": "EXP_MAINTENANCE"
},
{
"$id": "5",
"Caption": "CPI",
"DefaultRows": 999,
"Id": 4,
"ModuleId": 3,
"TodaySection": "TODAY.CIP"
},
{
"$id": "6",
"Caption": "Notifications",
"DefaultRows": 999,
"Id": 5,
"ModuleId": 1,
"TodaySection": "EXP_NOTIFICATIONS"
},
{
"$id": "7",
"Caption": "Tasks",
"DefaultRows": 999,
"Id": 6,
"ModuleId": 4,
"TodaySection": "EXP_TASKS"
},
{
"$id": "8",
"Caption": "Support cases",
"DefaultRows": 999,
"Id": 7,
"ModuleId": 5,
"TodaySection": "EXP_SUPPORT"
},
{
"$id": "9",
"Caption": "Call ToDo",
"DefaultRows": 999,
"Id": 8,
"ModuleId": 12,
"TodaySection": "CALL_TODO"
},
{
"$id": "10",
"Caption": "My VoiceMail Messages",
"DefaultRows": 999,
"Id": 9,
"ModuleId": 12,
"TodaySection": "MY_VOICEMAIL"
},
{
"$id": "11",
"Caption": "Today Call-Log",
"DefaultRows": 999,
"Id": 10,
"ModuleId": 12,
"TodaySection": "TODAY_CALL_LOG"
},
{
"$id": "12",
"Caption": "My Discussions",
"DefaultRows": 999,
"Id": 11,
"ModuleId": 15,
"TodaySection": "TODAY_MY_DISCUSSION"
},
{
"$id": "13",
"Caption": "Legal Control appointments",
"DefaultRows": 20,
"Id": 12,
"ModuleId": 19,
"TodaySection": "LC_APPOINTMENTS"
},
{
"$id": "14",
"Caption": "Repairs2",
"DefaultRows": 999,
"Id": 13,
"ModuleId": 20,
"TodaySection": "EXP_REPAIRS2"
},
{
"$id": "15",
"Caption": "Maintenance2",
"DefaultRows": 999,
"Id": 14,
"ModuleId": 20,
"TodaySection": "EXP_MAINTENANCE2"
},
{
"$id": "16",
"Caption": "CPI2",
"DefaultRows": 999,
"Id": 15,
"ModuleId": 22,
"TodaySection": "TODAY.CIP2"
},
{
"$id": "17",
"Caption": "Overdue Maintenances2",
"DefaultRows": 999,
"Id": 16,
"ModuleId": 20,
"TodaySection": "EXP_MAIN_OVER2"
},
{
"$id": "18",
"Caption": "Top CIPs",
"DefaultRows": 50,
"Id": 17,
"ModuleId": 22,
"TodaySection": "TODAY.CIP.TOP"
},
{
"$id": "19",
"Caption": "Measures",
"DefaultRows": 999,
"Id": 18,
"ModuleId": 23,
"TodaySection": "TODAY.MEASURES"
},
{
"$id": "20",
"Caption": "Under min. stock",
"DefaultRows": 999,
"Id": 19,
"ModuleId": 8,
"TodaySection": "TODAY.STOCK_UNDER_MINIMUM"
}
],
"Total": 19,
"AggregateResults": null,
"Errors": null
}
The controller does get called and the content is transfered (see atached image). But nothing is showing up.
I have no idea how to determine what could be wrong!!!!
Here is the controller method:
Function [Get](type As String, <
Kendo.Mvc.UI.DataSourceRequest
()> request As DataSourceRequest) As ActionResult
Dim result As Object
Using daa As New DataAccessAdapter(ConfigurationManager.AppSettings("ConnectionString"))
Dim linq As New LinqMetaData(daa)
Dim assets As IQueryable(Of AitTodaySectionEntity) = linq.AitTodaySection
result = assets.ToDataSourceResult(request)
End Using
Dim json As New JsonNetResult
json.Data = result
Return json
End Function