Name

IsDBNull

Synopsis

Boolean = DataReader.IsDBNull(Int32 columnOrdinal);

Returns a Boolean value that indicates whether the indicated column contains a null value. You can call this method to check for a null value before you call a typed accessor method such as GetByte( ) or GetChar( ) and thereby avoid raising an error.

Example

The following code tests for a null value before attempting to retrieve an integer value:

int rowVal;



if (r.IsDbNull(i))

{

    // Use default value. Row is null.

    rowVal = 0;

}

else

{

    // Use database value.

    rowVal = (int)r[i];

}