Date edit format on grid incell editing

[Ale]

Hi everyone,
I have a grid with a DateTime inside, I want to modify it with inCell editing.

This is my grid definition:

@(Html.Kendo().Grid(Model.row)
    .Name("grid")
    .Columns(columns =>
    {
        columns.Bound(l => l.LRId).Hidden();
        columns.Bound(l => l.StartDate).Format("{0:d}");
        columns.Bound(l => l.Amount);

        columns.Command(command => command.Custom("logicalDelete"));//.Click("udmAltDelete"));
    })
    .ToolBar(toolbar => toolbar.Create())
    .Editable(ed => ed.Mode(GridEditMode.InCell))
    .DataSource(ds => ds
        .Ajax()
        .Batch(true)
        .ServerOperation(false)
        .Model(model =>
        {
            model.Id(l => l.LRId);
        })
        )
)

When the grid show data correctly formatted with "Short date format" (look image attached: View.png),
but when i modify the date the grid modify the format (look image attached: Modify.png).

How can I have the same format for view and editing data?

[Vladimir Iliev]

Hi Alessio,

There are several ways to achieve the desired behavior and which one you would choose depends entirely on you and the exact setup that you have. For example you can create custom editor template for the required field in which to set the needed format to the DateTimePicker or use the Edit event of the Grid as demonstrated below:

.Events(e => e.Edit("onEdit"))

function onEdit(e) {
    //replace OrderDate with your field name
    var datePicker = e.container.find("#OrderDate").data("kendoDateTimePicker");
    datePicker.setOptions({ format: "{0:d}" });
    datePicker.value(datePicker.value());
}

Regards,
Vladimir Iliev
Telerik

 

 

[Mandar]

I try to add datepicker in grid cell but there are following problems are occured
1)its not assign to cell
2) date is not formatted as 'dd/MM/yyyy'
3)onclick cell value not show and empty textbox display

I attached the gif file which will explain the my problems

I use latest updated kendo library for grid

Please give me sample project if possible.

my grid configuration is batch edit 'true' and 'GridEditMode is incell'

 

 

[Viktor Tachev]

Hi Mandar,

In order to specify the date format manually for a column you need to define it in the Format() setting. For example:

columns.Bound(p => p.DateField).Format("{0:dd/MM/yyyy}");

Also, if you would like to specify custom editors for some of the fields you should use an approach similar to the one described in the article below:

• http://docs.telerik.com/aspnet-mvc/helpers/grid/templating/editor-templates

Regards,
Viktor Tachev
Telerik by Progress