Partager via


Propriété PipelineBuffer.Item

Gets the data stored in a buffer column.

Espace de noms :  Microsoft.SqlServer.Dts.Pipeline
Assembly :  Microsoft.SqlServer.PipelineHost (en Microsoft.SqlServer.PipelineHost.dll)

Syntaxe

'Déclaration
Public Default Property Item ( _
    columnIndex As Integer _
) As Object 
    Get 
    Set
'Utilisation
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 prend en charge l'utilisation de propriétés indexées, mais pas la déclaration de nouvelles propriétés.

Paramètres

  • columnIndex
    Type : System.Int32
    The index of the column in the buffer row.

Valeur de propriété

Type : System.Object
The data stored in the buffer column as an object.

Notes

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.

Voir aussi

Référence

PipelineBuffer Classe

Espace de noms Microsoft.SqlServer.Dts.Pipeline