Share via


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

See Also

Reference

ForEachADOEnumerator Class

Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO Namespace