• Artigo

Propriedade do RDL Type

Gets or sets a value that indicates what type of object to enumerate over.

Namespace:  Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO
Assembly:  Microsoft.SqlServer.ForEachADOEnumerator (em Microsoft.SqlServer.ForEachADOEnumerator.dll)

Sintaxe

'Declaração
Public Property Type As ADOEnumerationType
    Get
    Set
'Uso
Dim instance As ForEachADOEnumerator
Dim value As ADOEnumerationType

value = instance.Type

instance.Type = value

public ADOEnumerationType Type { get; set; }

public:
virtual property ADOEnumerationType Type {
    ADOEnumerationType get () sealed;
    void set (ADOEnumerationType value) sealed;
}

abstract Type : ADOEnumerationType with get, set
override Type : ADOEnumerationType with get, set

final function get Type () : ADOEnumerationType
final function set Type (value : ADOEnumerationType)

Valor da propriedade

Tipo: Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO. . :: . .ADOEnumerationType
A value from the ADOEnumerationType enumeration that indicates what to enumerate over.

Implementa

IDTSForEachADOEnumerator. . :: . .Type

Exemplos

The following code sample shows how to use the Type property to differentiate the type of object, allowing different code to be written for handling different business logic, toggling check boxes in a user interface, or running any other special processes.

m_Enum = (ForEachADOEnumerator)FEEHost.InnerObject;
    if( m_Enum != null )
    {
        switch( m_Enum.Type )
        {
            case ADOEnumerationType.EnumerateAllRows:
                // Insert custom code here.
                break;

            case ADOEnumerationType.EnumerateRowsInFirstTable:
                // Insert custom code here.
                break;

            case ADOEnumerationType.EnumerateTables:
                // Insert custom code here.
                break;

            default:
                // Insert custom code here.
                break;
        }