Edit problem for datetime column in dd/MM/YYYY formate

[Dheeraj]

Hi,
      in my grid I have column defined as datetime for that i am applying DataFormatString="{0:dd/MM/yyyy}" to show it in dd/MM/YYY formate instead of default MM/dd/YYYYY formate. Now on edit of row i am getting client side scipt error like-

" The string was not recognized as a valid DateTime."

I am using <telerik:GridEditCommandColumn>  for inline editing.

How to avod this error plz help me regarding this.

Regards,
Dheeraj

[Martin]

Hello Dheeraj,

Could you please verify whether you bind your column to a valid DateTime object? I have tested the code snippets bellow and they run as expected on my side:

Markup:

<telerik:RadGrid ID="RadGrid1" runat="server" OnNeedDataSource="RadGrid1_NeedDataSource"
    AutoGenerateColumns="false">
    <MasterTableView EditMode="InPlace">
        <Columns>
            <telerik:GridDateTimeColumn DataField="MyDateTimeField1" DataFormatString="{0:dd/MM/yyyy}" HeaderText="MyDateTimeColumn" UniqueName="MyDateTimeColumn">
            </telerik:GridDateTimeColumn>
            <telerik:GridBoundColumn DataField="MyDateTimeField2" DataFormatString="{0:dd/MM/yyyy}" HeaderText="MyBoundColumn" UniqueName="MyBoundColumn">
            </telerik:GridBoundColumn>
            <telerik:GridEditCommandColumn>
            </telerik:GridEditCommandColumn>
        </Columns>
    </MasterTableView>
</telerik:RadGrid>

Code behind:

protected void RadGrid1_NeedDataSource(object source, GridNeedDataSourceEventArgs e)
{
    DataTable table = new DataTable();
    table.Columns.Add("MyDateTimeField1", typeof(DateTime));
    table.Columns.Add("MyDateTimeField2", typeof(DateTime));
    for (int i = 0; i < 10; i++)
    {
        table.Rows.Add(DateTime.Now.AddDays(i),DateTime.Now.AddDays(-i));
    }
    RadGrid1.DataSource = table;
}

I hope this helps,
Martin
the Telerik team