IDataRecord.IsDBNull Method

Return whether the specified field is set to null.

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

bool IsDBNull (
	int i
boolean IsDBNull (
	int i
function IsDBNull (
	i : int
) : boolean
Not applicable.



The index of the field to find.

Return Value

true if the specified field is set to null; otherwise, false.

Exception typeCondition


The index passed was outside the range of 0 through FieldCount.

Call this method to see if there are null column values before calling the typed get methods (for example, GetByte, GetChar, and so on) to avoid raising an error.

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

Community Additions