This documentation is archived and is not being maintained.

DataRow.IsNull Method (Int32)

Gets a value that indicates whether the column at the specified index contains a null value.

Namespace: System.Data
Assembly: System.Data (in

public bool IsNull (
	int columnIndex
public boolean IsNull (
	int columnIndex
public function IsNull (
	columnIndex : int
) : boolean
Not applicable.



The zero-based index of the column.

Return Value

true if the column contains a null value; otherwise, false.

The following example changes the value of a column to a null value, and then uses the IsNull method to determine whether the value is null.

Private Sub IsValNull()
    ' Assuming the DataGrid is bound to a DataTable.
    Dim table As DataTable = CType(DataGrid1.DataSource, DataTable)
    Dim row As DataRow = table.Rows(datagrid1.CurrentCell.RowNumber)
    row(1) = System.DBNull.Value
End Sub

Windows 98, Windows Server 2000 SP4, Windows CE, Windows Millennium Edition, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

.NET Framework

Supported in: 3.0, 2.0, 1.1, 1.0

.NET Compact Framework

Supported in: 2.0, 1.0

XNA Framework

Supported in: 1.0