Item 屬性

Gets the data stored in a buffer column.

命名空間：  Microsoft.SqlServer.Dts.Pipeline
組件：  Microsoft.SqlServer.PipelineHost (在 Microsoft.SqlServer.PipelineHost.dll 中)

語法

'宣告
Public Default Property Item ( _
    columnIndex As Integer _
) As Object
    Get
    Set
'用途
Dim instance As PipelineBuffer
Dim columnIndex As Integer
Dim value As Object

value = instance(columnIndex)

instance(columnIndex) = value

public Object this[
    int columnIndex
] { get; set; }

public:
property Object^ default[int columnIndex] {
    Object^ get (int columnIndex);
    void set (int columnIndex, Object^ value);
}

member Item : Object with get, set

JScript 支援索引屬性的使用，但不支援新屬性的宣告。

參數

• columnIndex
  型別：System. . :: . .Int32
  The index of the column in the buffer row.

屬性值

型別：System. . :: . .Object
The data stored in the buffer column as an object.

備註

The value stored in a buffer column can be accessed by using one of the data type accessor methods, such as the GetString method, or it can be accessed directly by using array access notation. Accessing a column in the PipelineBuffer by using the Item method is slower than using a data type accessor method because the PipelineBuffer detects the data type stored in the column and then calls the data type accessor method.

Buffer columns containing binary large objects (BLOB) data cannot be retrieved using the array access notation because the amount of data stored in the BLOB column may exceed the available memory. Instead, the GetBlobData method should be used.

請參閱

參考

PipelineBuffer類別

PipelineBuffer 成員

Microsoft.SqlServer.Dts.Pipeline 命名空間