PipelineBuffer.IsNull Method (Int32)

 

Applies To: SQL Server 2016 Preview

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

public bool IsNull(
    int columnIndex
)
public:
bool IsNull(
    int columnIndex
)
member IsNull : 
        columnIndex:int -> bool
Public Function IsNull (
    columnIndex As Integer
) As 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 null; 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 null.

See Also

PipelineBuffer Class
Microsoft.SqlServer.Dts.Pipeline Namespace

Return to top