Object DBNull Error

Question

I tried to follow some examples on the internet without success

I'm trying the following in a GridView1_RowDataBound methode

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        DataRowView drv = e.Row.DataItem as DataRowView;
        if (Convert.ToDateTime(drv["Created_Date"]).ToString("dd-MM-yyyy") == "01-01-1900" || (drv["Created_Date"].ToString().Equals(DBNull.Value))) //Check for this date
        {
            e.Row.Cells[11].Text = "test";
        }
    }
}

I'm still receiving a Object cannot be cast from DBNull to other types.

VDWWD · Accepted Answer · 2018-03-14 10:09:47Z

1

You have to use

string.IsNullOrEmpty(drv["Created_Date"].ToString())

However you should switch the first and second values in the if-statement. You are checking if the Created_Date is null AFTER you cast it. So if it is null, your code will still throw an error. So it is better to do something like this

if (string.IsNullOrEmpty(drv["Created_Date"].ToString()) || Convert.ToDateTime(drv["Created_Date"]) == new DateTime(1900, 1, 1))

answered Mar 14, 2018 at 10:09

VDWWD

35.7k23 gold badges67 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Object DBNull Error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related