Name

IsNull

Synopsis

Boolean isNull = DataRow.IsNull(DataColumn col)

Boolean isNull = DataRow.IsNull(Integer columnIndex)

Boolean isNull = DataRow.IsNull(String columnName)

Boolean isNull = DataRow.IsNull(DataColumn col, DataRowVersion drv)

Returns a value indicating whether the specified column contains a null value. An optional argument allows the DataRowVersion of the column to be specified.

Parameters

isNull

Returns a Boolean indicating the specified DataColumn contains a null value.

col

The DataColumn object tested for a null value.

columnIndex

The zero-based index of the DataColumn tested for a null value.

columnName

The name of the DataColumn tested for a null value.

drv

One of the DataRowVersion enumeration values described in Table 25-5.

Example

The following example demonstrates how to check if the first column in the row contains a null value using an overload of the IsNull( ) method:

DataRow row;



// ... load data into the row

if(row.IsNull(0))

{

    // ... code to process the null value

}

Note

The IsNull( ) method can test data in situations in which null values are sometimes allowed in a column, thereby preventing the AllowDBNull property of the column from being set to false.