bjornruysen bjornruysen - 1 month ago 4
C# Question

How can I set and get the value of a dropdownlist in a grid in Kendo UI MVC?

I'm working with KendoUI MVC in MVC3.

I managed to get a dropdown in a grid column. But I have no clue on how to set the selected value, and when I save it doesn't save my selected value.

The grid

@using Perseus.Areas.Communication.Models
@using Perseus.Common.BusinessEntities;

<div class="gridWrapper">
.Columns(colums =>
colums.Bound(o => o.communication_type_id)
.ClientTemplate("#: communication_type #")
colums.Bound(o => o.sequence).Width(180);
colums.Bound(o => o.remarks);
colums.Command(command => command.Edit()).Width(50);
.Editable(edit => edit.Mode(GridEditMode.InLine))
.DataSource(dataSource => dataSource
.Model(model => model.Id(o => o.communication_id))
.Read(read => read.Action("AjaxBinding", "Communication", new { id = @ViewBag.addressId }))
.Update(update => update.Action("Update", "Communication"))
.Sort(sort => { sort.Add(o => o.sequence).Ascending(); })

The EditorTemplate "_communicationDropDown

@model Perseus.Areas.Communication.Models.CommunicationModel

@(Html.Kendo().DropDownListFor(c => c.communication_type_id)


I think this is an important one to point out is that the DropDownList name should match the column name attribute. The html attribute name="", not the heading of the column. The name attributes must match for this to work, since you are substituting the default editor control with another control coming from an editor template to take its place during the edit operation. If the names do not match when the DOM is serialized back into the model for the update operation, the value from the editor template control will be ignored. By default it is the property variable name that appears in the model class, unless overriden in the mark up.

(Answer edited to include the insert record operation).

Here is a working example:

Model Class:

public class Employee
    public int EmployeeId { get; set; }
    public string Name { get; set; }
    public string Department { get; set; }


     .Columns(columns =>
         columns.Bound(p => p.Name).Width(50);
         columns.Bound(p => p.Department).Width(50).EditorTemplateName("DepartmentDropDownList");
         columns.Command(command => command.Edit()).Width(50);
     .ToolBar(commands => commands.Create())
     .Editable(editable => editable.Mode(GridEditMode.InLine))
     .DataSource(dataSource => dataSource
         .Model(model => model.Id(p => p.EmployeeId))
         .Read(read => read.Action("GetEmployees", "Home")) 
         .Update(update => update.Action("UpdateEmployees", "Home"))
         .Create(create => create.Action("CreateEmployee", "Home"))

Partial view editor template, file name "DepartmentDropDownList", located in the EditorTemplates folder that is specific to this view. ie. Home\Views\EditorTemplates\DepartmentDropDownList.cshtml

@model string

    .Name("Department")  //Important, must match the column's name
    .BindTo(new string[] { "IT", "Sales", "Finance" }))  //Static list of departments, can bind this to anything else. ie. the contents in the ViewBag

Controller for the Read operation:

public ActionResult GetEmployees([DataSourceRequest]DataSourceRequest request)
    List<Employee> list = new List<Employee>();
    Employee employee = new Employee() { EmployeeId = 1, Name = "John Smith", Department = "Sales" };
    employee = new Employee() { EmployeeId = 2, Name = "Ted Teller", Department = "Finance" };

    return Json(list.ToDataSourceResult(request));

Controller for the Update operation:

public ActionResult UpdateEmployees([DataSourceRequest] DataSourceRequest request, Employee employee)
    return Json(new[] { employee }.ToDataSourceResult(request, ModelState));

Controller for the Create operation:

public ActionResult CreateEmployee([DataSourceRequest] DataSourceRequest request, Employee employee)
    employee.EmployeeId = (new Random()).Next(1000);  
    return Json(new[] { employee }.ToDataSourceResult(request, ModelState));