GetEnumerator 方法
Returns a managed LogEntryInfoEnumerator to iterate over the LogEntryInfos collection.
命名空间: Microsoft.SqlServer.Dts.Runtime
程序集: Microsoft.SqlServer.ManagedDTS(在 Microsoft.SqlServer.ManagedDTS.dll 中)
语法
声明
Public Function GetEnumerator As LogEntryInfoEnumerator
用法
Dim instance As LogEntryInfos
Dim returnValue As LogEntryInfoEnumerator
returnValue = instance.GetEnumerator()
public LogEntryInfoEnumerator GetEnumerator()
public:
LogEntryInfoEnumerator^ GetEnumerator()
member GetEnumerator : unit -> LogEntryInfoEnumerator
public function GetEnumerator() : LogEntryInfoEnumerator
示例
The following code sample creates a LogEntryInfoEnumerator using the GetEnumerator method, and then iterates over the collection.
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
namespace LogEntryInfosTest
{
class Program
{
static void Main(string[] args)
{
// The package is one of the SSIS Samples.
string mySample = @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx";
// Create the Application, and load the sample.
Application app = new Application();
Package pkg = app.LoadPackage(mySample, null);
//Create the Enumerator.
LogEntryInfos leInfos = pkg.LogEntryInfos;
LogEntryInfoEnumerator myEnumerator = leInfos.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);
Console.WriteLine();
}
}
}
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Namespace LogEnTryInfosTest
Class Program
Shared Sub Main(ByVal args() As String)
' The package is one of the SSIS Samples.
Dim mySample As String = "C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx"
' Create the Application, and load the sample.
Dim app As Application = New Application()
Dim pkg As Package = app.LoadPackage(mySample,Nothing)
'Create the Enumerator.
Dim leInfos As LogEnTryInfos = pkg.LogEnTryInfos
Dim myEnumerator As LogEnTryInfoEnumerator = leInfos.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
Console.WriteLine()
End Sub
End Class
End Namespace
Sample Output:
The collection contains the following values:
[0] Microsoft.SqlServer.Dts.Runtime.LogEntryInfo