Export (0) Print
Expand All

SqlDataReader.IsDBNull Method

Gets a value that indicates whether the column contains non-existent or missing values.

Namespace:  System.Data.SqlClient
Assembly:  System.Data (in System.Data.dll)

Public Overrides Function IsDBNull ( _
	i As Integer _
) As Boolean


Type: System.Int32

The zero-based column ordinal.

Return Value

Type: System.Boolean
true if the specified column value is equivalent to DBNull; otherwise false.



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

Imports System
Imports System.Data
Imports System.Data.SqlClient

Module Module1
   Sub Main()
      Using connection As New SqlConnection("Data Source=(local);Initial Catalog=AdventureWorks2012;Integrated Security=SSPI")
         Dim command As New SqlCommand("SELECT p.FirstName, p.MiddleName, p.LastName FROM HumanResources.Employee AS e" & _
                                       " JOIN Person.Person AS p ON e.BusinessEntityID = p.BusinessEntityID;", connection)
         Dim reader As SqlDataReader = command.ExecuteReader()
         While reader.Read()

            ' display middle name only of not null 
            If Not reader.IsDBNull(reader.GetOrdinal("MiddleName")) Then
               Console.Write(" {0}", reader.GetString(reader.GetOrdinal("MiddleName")))
            End If

            Console.WriteLine(" {0}", reader.GetString(reader.GetOrdinal("LastName")))
         End While
      End Using 
   End Sub 
End Module

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0, 1.1

.NET Framework Client Profile

Supported in: 4, 3.5 SP1
© 2015 Microsoft