Share via

  • Article

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)

Syntax

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

returnValue = instance.IsNull(columnIndex)

public bool IsNull(
    int columnIndex
)

public:
bool IsNull(
    int columnIndex
)

member IsNull : 
        columnIndex:int -> bool 

public function IsNull(
    columnIndex : int
) : boolean

Parameters

  • 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.

Remarks

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).