PipelineBuffer.Item Property

  • 發行項

Gets the data stored in a buffer column.

命名空間: Microsoft.SqlServer.Dts.Pipeline
組件: Microsoft.SqlServer.PipelineHost (in microsoft.sqlserver.pipelinehost.dll)

語法

'宣告
Public Default Property Item ( _
    columnIndex As Integer _
) As Object

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

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

/** @property */
public Object get_Item (int columnIndex)

/** @property */
public void set_Item (int columnIndex, Object value)

參數

  • columnIndex
    The index of the column in the buffer row.

屬性值

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 and GetBytes methods should be used.

執行緒安全性

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.

平台

開發平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

目標平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

請參閱

參考

PipelineBuffer Class
PipelineBuffer Members
Microsoft.SqlServer.Dts.Pipeline Namespace