C#.NET MVC Razor View - can't compare DBNull value

Question

Trying to determine whether a datetime value in datarow is null. i have no idea why this shouldn't work. i've also tried casting to string etc but keep getting same error:

Object cannot be cast from DBNull to other types.

This error doesn't make sense to me, i'm not trying to cast it. I've tried many variants in trying to compare the datarow to DBNull, to no avail.

if(dataRows[0]["Reply_Deadline"] != DBNull.Value)
{
    if(Convert.ToDateTime(dataRows[0]["Reply_Deadline"]) <= DateTime.Now)
    {
        deadlinePast = true;
    }
}

Thanks

Have you tried the Convert.IsDBNull(...) method? Apparently calling DBNull.Value is pretty rare. msdn.microsoft.com/en-us/library/… — Drew Kennedy
– Drew Kennedy, Commented Jul 21, 2015 at 14:43
I did, as per the example below, but i'm still getting the same error... — AncientYouth
– AncientYouth, Commented Jul 21, 2015 at 14:51

Steve Greene · Accepted Answer · 2015-07-21 14:44:33Z

2

Try

if (!Convert.IsDBNull(dataRows[0]["Reply_Deadline"]))

https://msdn.microsoft.com/en-us/library/system.convert.isdbnull(v=vs.110).aspx

answered Jul 21, 2015 at 14:44

Steve Greene

12.4k2 gold badges36 silver badges56 bronze badges

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

1 Comment

Steve Greene Over a year ago

here's another alternative: stackoverflow.com/questions/4604414/…

Collectives™ on Stack Overflow

C#.NET MVC Razor View - can't compare DBNull value

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related