PipelineBuffer.IsNull Method

Article
12/03/2008

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

public bool IsNull (
    int columnIndex
)

public:
bool IsNull (
    int columnIndex
)

public boolean IsNull (
    int columnIndex
)

public function IsNull (
    columnIndex : int
) : boolean

Parameters

columnIndex
The index of the column in the buffer row.

Return Value

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.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms