This is a migrated thread and some comments may be shown as answers.

String was not recognized as a valid DateTime.

3 Answers 661 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Joshy Varghese asked on 21 Oct 2011, 02:58 PM

Hi,
I'm using latest version Q2 2011 telerik controls. I'm getting an exception on grid ItemDataBound event only on edit command. Initial databound and paging, sorting are good.

In my database both fields are datetime.

StartTime                                    EndTime
2011-09-30 00:00:00.000            2011-09-30 15:34:33.203

In the radGrid
Start Time                                     End Time
9/30/2011 12:00:00 AM                9/30/2011 3:34:33 PM

EditMode

="InPlace"

OnNeedDataSource="grdTime_NeedDataSource" (binding the data on server side using EntityFramework)
<Columns>

<telerik:GridDateTimeColumn DataField="StartTime" HeaderButtonType="TextButton" HeaderText="Start Time" ItemStyle-HorizontalAlign="Left" UniqueName="StartTime" ItemStyle-Width="100px" HeaderStyle-Width="100px" ReadOnly="true" DataType="System.DateTime">

</telerik:GridDateTimeColumn>

<telerik:GridDateTimeColumn DataField="EndTime" HeaderButtonType="TextButton" HeaderText="End Time" ItemStyle-HorizontalAlign="Left" UniqueName="EndTime" ItemStyle-Width="100px" HeaderStyle-Width="100px" PickerType="DateTimePicker" DataType="System.DateTime">

</telerik:GridDateTimeColumn>

</Columns>

Getting the "String was not recognized as a valid DateTime." exception on hitting edit button.

Thanks!

3 Answers, 1 is accepted

answered on 01 Nov 2016, 05:09 PM

Hi there.

I have a similar scenario. I'm getting the same error when I hit the edit button only.

Either the ItemDataBound event is working good and the grid is filtering good with EnableRangeFiltering="true".

I'm sending the data from a storeprocedure as (the default database's languaje is english):

CONVERT(DATETIME ,[dScheduled] ,103) [dScheduled]

I already tried many conbinations in the EditDataFormatString property as "yyyy-MM-dd", "dd/MM/yyyy" and the like.

My code is this:

<telerik:GridDateTimeColumn DataField="dScheduled" SortExpression="dScheduled" UniqueName="dScheduled" DataType="System.DateTime" FilterControlWidth="100px" HtmlEncode="False" PickerType="DatePicker" CurrentFilterFunction="Between" AndCurrentFilterFunction="Between" ShowFilterIcon="False" EnableRangeFiltering="true" DataFormatString="{0:dd/MM/yyyy}" EditDataFormatString="yyyy-MM-dd" FilterDateFormat="dd/MM/yyyy" AutoPostBackOnFilter="True">

</telerik:GridDateTimeColumn>

I add the Stack Trace, just in case:

[FormatException: The string was not recognized as a valid DateTime.]

Telerik.Web.UI.RadDatePicker.set_DbSelectedDate(Object value) +805

Telerik.Web.UI.GridDateTimeColumnEditor.set_Text(String value) +43

Telerik.Web.UI.GridBoundColumn.OnDataBindColumn(Object sender, EventArgs e) +1084

System.Web.UI.Control.OnDataBinding(EventArgs e) +84

System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +150