BreakpointTargets.GetEnumerator Method

Статья
12/15/2008

Returns a BreakpointTargetEnumerator that can iterate through the BreakpointTargets collection.

Пространство имен: Microsoft.SqlServer.Dts.Runtime
Сборка: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

Синтаксис

'Декларация
Public Function GetEnumerator As BreakpointTargetEnumerator

public BreakpointTargetEnumerator GetEnumerator ()

public:
BreakpointTargetEnumerator^ GetEnumerator ()

public BreakpointTargetEnumerator GetEnumerator ()

public function GetEnumerator () : BreakpointTargetEnumerator

Возвращаемое значение

A BreakpointTargetEnumerator for the BreakpointTargets collection.

Пример

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

Синхронизация потоков

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.

Платформы

Платформы разработки

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

Целевые платформы

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

См. также

Справочник

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

Поделиться через