Why is my comparison to null, of a value contained in a System.Data.DataRow object, failing?

Question

I am converting an app's database from Access to MS SQL Server and encountered a problem with a line of code that checks to see if an item retrieved from the database is null.

It essentially looks like this:

if (System.Data.DataRow["foo"] == null)
{
    //do something
}

I know the value in column "foo" is null, but the check fails. It works against an Access database, but not MS SQL Server. I can see why. The call is returning "{}" instead of null. Why?

score 2 · Accepted Answer · answered Oct 07 '11 at 14:41

2

Try checking against DbNull.Value instead of null

answered Oct 07 '11 at 14:41

Sergey Kudriavtsev

10,328
4
43
68

score 1 · Answer 2 · answered Oct 07 '11 at 14:40

1

Try:

if (System.Data.DataRow["foo"].IsDBNull)

answered Oct 07 '11 at 14:40

Marco

56,740
14
129
152

Why is my comparison to null, of a value contained in a System.Data.DataRow object, failing?

2 Answers2