object cannot be cast from dbnull to other types

[D.SRINIVASA]

Hi,

I am Srinivasa

in my project i have a problem for bind the Date form backend table to RadDatePicker in Rad Grid. But in my data Base in date column i have a empty value. 

here i am using the client side coding for bind Date data to RadDatePicker in RadGrid like the following way...

                       <telerik:RadDatePicker ID="actstart" runat="server" MaxDate='<%# Convert.ToDateTime(Eval("early_start_display")).ToString("dd/MMM/yyyy") %>' Width="100px" Calendar-ShowOtherMonthsDays="false" 
                        Calendar-ShowRowHeaders="false" DbSelectedDate='<%# Bind("actual_start") %>' DateInput-DateFormat="MM/dd/yyyy">
                       </telerik:RadDatePicker>

But it shows the error at the time of Date Column Null value in the DataBase...

Error is :

object cannot be cast from dbnull to other types

Please Help me.

Thanks

D.Srinivasa

[Veli]

Hello Srinivasa,

Which of your fields contains the null value in this case - early_start_display or actual_start? You are binding the actual_start field to the DbSelectedDate property of the picker. This property (as the name suggests) expects a DB value and is designed to handle null values. Also, is the date picker in  the ItemTemplate or the EditItemTemplate of the grid column? Assuming the early_start_display field contains the DbNull value and the picker is in the EditItemTemplate, here is RadGrid's ItemDataBound event handler you can use to explicitly check for null values for this field:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
    if (e.Item is GridEditableItem && e.Item.IsInEditMode)
    {
        RadDatePicker picker = (RadDatPicker)e.Item.FindControl("actstart");
        object startDate = DataBinder.Eval(e.Item.DataItem, "early_start_display");
        if (startDate != null && startDate != DBNull.Value)
        {
            picker.MaxDate = Convert.ToDateTime(startDate);
        }
    }
}

With the above code, you should now remove the MaxDate='<%# Convert.ToDateTime(Eval("early_start_display")).ToString("dd/MMM/yyyy") %>' portion from your markup and have the ItemDataBound event handler handle this for  you.

Veli
the Telerik team