how to detect if column in IDataReader has a NULL value?

[Jeff]

hi

..net 2.0

IDataReader reader;
if (reader["field1"] == null)
{
}

This if test don't come true. I've just tested it with a NULL value in
field1, and the code block within the if statement wasn't executed. Instead
it executed the else block (not shown here.)

any suggestions?

 

[sloan]

IDataReader idr;


if (!(idr.IsDBNull(0)))
{
myObject.MyGuid = idr.GetGuid(0);
}

 

[Martin Honnen]

IDataReader reader;
if (reader["field1"] == null)

if (System.DBNull.Value.Equals(reader["field1"]))