Hello,

Use the DbSelectedDate property than SelectedDate to get or set the date content of RadDatePicker in a database friendly way. The only difference with SelectedDate is that it will not throw an exception if the new value is null or DBNull. Setting a null value will internally revert the SelectedDate to the null value, i.e. the input value will be empty.

ASPX:
 <telerik:RadDatePicker ID="dtStart" runat="server" Width="200px" DbSelectedDate='<%# Bind("StartDate") %>'/>


Regards,
Shinu.

Shinu,

What happens when one tries that way and gets this error:

Value of '1/1/1900 12:00:00 AM' is not valid for 'SelectedDate'. 'SelectedDate' should be between 'MinDate' and 'MaxDate'.
Parameter name: SelectedDate

here is the line in markup:

<telerik:RadDatePicker ID="rdpEndDate" runat="server" ZIndex="10000" DateInput-DateFormat="MM/dd/yyyy" DateInput-DisplayDateFormat="MM/dd/yyyy" DbSelectedDate='<%# Eval("EndDate") %>' Enabled="false" />

I've tried it with this method, too:

SelectedDate='<%# If((Eval("EndDate") IsNot Nothing AndAlso TypeOf Eval("EndDate") Is DateTime), Convert.ToDateTime(Eval("EndDate")), CType(Nothing, System.Nullable(Of DateTime))) %>'

Same error as above.

Help?

Jerry

Hello Jerry,

If using DbSelectedDate the application should not throw an exception if the new value is null or DBNull. Setting a null value should internally revert the SelectedDate to the null value, i.e. the input value will be empty.

Therefore, we would need more details in order to locate the cause of the issue. Can you provide us with a set of steps to follow in order to create a project replicating the erroneous behavior?

Kind regards,
Tsvetina
the Telerik team

Tsvetina,

I resolved the issue (as per this thread http://www.telerik.com/community/forums/aspnet/grid/null-raddatepicker-in-grid-error.aspx )

It was an empty string returning from a stored proc that should have been returning a Null value.