Trying to bind date to a datepicker

[Jocelyn]

Hi,

like the title says, I am trying to bind a date to a date picker.

Here is my code:

<telerik:RadDatePicker ID="rdpDateDebut" runat="server" SelectionOnFocus="SelectAll"
    Width="100px" DbSelectedDate='<%# Bind("Date") %>'>
</telerik:RadDatePicker>

This is inside a ascx used in an edit form UserControl.

I always got the same error:

Uncaught Sys.WebForms.PageRequestManagerServerErrorException: Sys.WebForms.PageRequestManagerServerErrorException: Impossible de créer un objet de type 'System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]' à partir de sa représentation sous forme de chaîne, '', pour la propriété 'SelectedDate'.  

My code looks very simple and I don't understand this error.

Sorry, the error is in french.

Thanks.

[Vasil]

Hi Jocelyn,

The error means that "Date" field that you are binding to does not contain valid date, and can't be cast to DateTime object.

This usually happens when you store the date in your database server as string in culture different from the one that you use in your ASP server. You should store the date time as datetime type and not a string in your database, or to make sure that the string can be parsed successfully using the DateTime.Parse method in the InvariantCulture.

Regards,
Vasil
the Telerik team