Kendo DataSource How to define a Model.Id when using DataTable

Question

When defining a DataSource within @(Html.Kendo().Grid(Model), I have successfully used

.DataSource( dataSource => .Ajax( ).Model( model => model.Id( m => m.PROPERTY ) ) )

where PROPERTY is a property of the object that is the model. What is the correct syntax for defining Model.Id if the Model is a System.Data.DataTable and the Id column in the DataTable is TableId?

In other words, model.Id( m => ??? ).

I have tried, model.Id( m => Model.PrimaryKey ), which seems to satisfy the requirement that model.Id be set, but the Update Action (.Update(update => update.Action("MyUpdateMethod", "MyController")) doesn't ever hit, so I think there must still be something wrong.

I didn't even know you could bind it to a DataTable. If no one has an idea on how to do it, you may just need to define it in JavaScript instead of using an MVC helper. — CodingWithSpike
In plain JavaScript you would set new kendo.data.DataSource({ schema: { model: { id: "PrimaryKey" } } }); if you wanted to convert to JS instead of MVC helper, the easiest thing to do is use the MVC helper once, view the page in your browser, and copy/paste the generated JS code. Then replace your MVC helper razor code with the generated JS. — CodingWithSpike

Bryan Hobbs Bryan Hobbs · Accepted Answer · 2013-09-17T18:42:23

You can bind to a DataTable. In fact, we do a lot of dynamic grids and DataTable is our only recourse. Binding is a little different, though.

A snippet for one of ours is like this:

@model System.Data.DataTable
@(Html.Kendo().Grid(Model)
    .Name("SomeGrid")
    .Columns(columns=>
      { 
          foreach(System.Data.DataColumn column in Model.Columns)
          {
              columns.Bound(column.ColumnName).Title(column.Caption).Width(200);
          }
       }
    )
    .Selectable(selectable=>selectable
       .Type(GridSelectionType.Row)
    )
    .DataSource(dataSource => dataSource
        .Ajax()
        .Model(model =>
             {
                 foreach(System.Data.DataColumn column in Model.Columns)
                 { 
                     model.Field(column.ColumnName,column.DataType);
                 }
             }
         )
         .Read(read=>Action("SomeMethod", "SomeController"))
         .PageSize(20)
     )

Kendo DataSource How to define a Model.Id when using DataTable

2 Answers