Delen via

  • Artikel

ForEachADOEnumerator.Type Property

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 (in Microsoft.SqlServer.ForEachADOEnumerator.dll)

Syntax

'Declaration
Public Property Type As ADOEnumerationType
    Get
    Set
'Usage
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)

Property Value

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

Implements

IDTSForEachADOEnumerator.Type

Examples

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;
        }