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)

public ADOEnumerationType Type { get; set; }

Property Value

Type: Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO.ADOEnumerationType

A value from the ADOEnumerationType enumeration that indicates what to enumerate over.

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;
        }
Return to top
Show: