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