PipelineBuffer.IsNull Method

Checks to see if the data in a buffer column is null.

Namespace:  Microsoft.SqlServer.Dts.Pipeline
Assembly:  Microsoft.SqlServer.PipelineHost (in Microsoft.SqlServer.PipelineHost.dll)


Public Function IsNull ( _
    columnIndex As Integer _
) As Boolean
Dim instance As PipelineBuffer
Dim columnIndex As Integer
Dim returnValue As Boolean

returnValue = instance.IsNull(columnIndex)
public bool IsNull(
    int columnIndex
bool IsNull(
    int columnIndex
member IsNull : 
        columnIndex:int -> bool 
public function IsNull(
    columnIndex : int
) : boolean


  • columnIndex
    Type: System.Int32
    The index of the column in the buffer row.

Return Value

Type: System.Boolean
true if the column contains nulla null reference (Nothing in Visual Basic); otherwise, false.


It is recommended that you call the IsNull method prior to calling a data type accessor method, such as GetBoolean, because the PipelineBuffer will produce a ColumnIsNullException if the column is nulla null reference (Nothing in Visual Basic).