BreakpointTargets.GetEnumerator Method

Returns a BreakpointTargetEnumerator that can iterate through the BreakpointTargets collection.

Espace de noms: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

Syntaxe

'Déclaration
Public Function GetEnumerator As BreakpointTargetEnumerator

public BreakpointTargetEnumerator GetEnumerator ()

public:
BreakpointTargetEnumerator^ GetEnumerator ()

public BreakpointTargetEnumerator GetEnumerator ()

public function GetEnumerator () : BreakpointTargetEnumerator

Valeur de retour

A BreakpointTargetEnumerator for the BreakpointTargets collection.

Exemple

The following code example creates a BreakpointTargetEnumerator using the GetEnumerator method, and then iterates over the collection.

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
using Microsoft.SqlServer.Dts.Tasks.FileSystemTask;

namespace BreakpointTarget_Expression
{
    class Program
    {
        static void Main(string[] args)
            {
            Package pkg = new Package();
            TaskHost taskHost = (TaskHost)pkg.Executables.Add("STOCK:FileSystemTask");
            BreakpointTargets bptargets = pkg.GetBreakpointTargets(taskHost, false);
            // Create the enumerator.
            BreakpointTargetEnumerator myEnumerator = bptargets.GetEnumerator();
            Console.WriteLine("The collection contains the following values:");
                int i = 0;
            while ((myEnumerator.MoveNext()) && (myEnumerator.Current != null))
                Console.WriteLine("[{0}] {1}", i++, myEnumerator.Current.Description);
        }
    }
}

Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Imports Microsoft.SqlServer.Dts.Tasks.FileSystemTask
 
Namespace BreakpointTarget_Expression
    Class Program
        Shared  Sub Main(ByVal args() As String)
            Dim pkg As Package =  New Package() 
            Dim taskHost As TaskHost = CType(pkg.Executables.Add("STOCK:FileSystemTask"), TaskHost)
            Dim bptargets As BreakpointTargets =  pkg.GetBreakpointTargets(taskHost,False) 
            ' Create the enumerator.
            Dim myEnumerator As BreakpointTargetEnumerator =  bptargets.GetEnumerator() 
            Console.WriteLine("The collection contains the following values:")
                Dim i As Integer =  0 
            While (myEnumerator.MoveNext()) &&(myEnumerator.Current <> Nothing)
            Console.WriteLine("[{0}] {1}",i = Console.WriteLine("[{0}] {1}",i + 1
            End While
        End Sub
    End Class
End Namespace

Sample Output:

The collection contains the following values:

[0] Break when the container receives the OnPreExecute event

[1] Break when the container receives the OnPostExecute event

[2] Break when the container receives the OnError event

[3] Break when the container receives the OnWarning event

[4] Break when the container receives the OnInformation event

[5] Break when the container receives the OnTaskFailed event

[6] Break when the container receives the OnProgress event

[7] Break when the container receives the OnQueryCancel event

[8] Break when the container receives the OnVariableValueChanged event

[9] Break when the container receives the OnCustomEvent event

Sécurité des threads

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Plateformes

Plateformes de développement

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Plateformes cibles

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Voir aussi

Référence

BreakpointTargets Class
BreakpointTargets Members
Microsoft.SqlServer.Dts.Runtime Namespace