GetEnumerator メソッド

ConnectionInfos コレクションを繰り返し処理できる ConnectionInfoEnumerator を返します。

名前空間:  Microsoft.SqlServer.Dts.Runtime
アセンブリ:  Microsoft.SqlServer.ManagedDTS (Microsoft.SqlServer.ManagedDTS.dll)

構文

'宣言
Public Function GetEnumerator As ConnectionInfoEnumerator
'使用
Dim instance As ConnectionInfos
Dim returnValue As ConnectionInfoEnumerator

returnValue = instance.GetEnumerator()
public ConnectionInfoEnumerator GetEnumerator()
public:
ConnectionInfoEnumerator^ GetEnumerator()
member GetEnumerator : unit -> ConnectionInfoEnumerator 
public function GetEnumerator() : ConnectionInfoEnumerator

使用例

次のコード サンプルでは、GetEnumerator メソッドを使用して ConnectionInfoEnumerator を作成し、コレクションに対して繰り返し処理を実行します。

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
namespace ConnInfos_Current
{
    class Program
    {
        static void Main(string[] args)
        {
            Application dtsApplication = new Application();
            ConnectionInfos connectionInfos = dtsApplication.ConnectionInfos;

            //Create the enumerator.
            ConnectionInfoEnumerator ConnInfoEnum = connectionInfos.GetEnumerator();
            Console.WriteLine("The collection contains the following values:");
            int i = 0;
            while ((ConnInfoEnum.MoveNext()) && (ConnInfoEnum.Current != null))
                Console.WriteLine("[{0}] {1}", i++, ConnInfoEnum.Current.Name);
        }
    }
}
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Namespace ConnInfos_Current
    Class Program
        Shared  Sub Main(ByVal args() As String)
            Dim dtsApplication As Application =  New Application() 
            Dim connectionInfos As ConnectionInfos =  dtsApplication.ConnectionInfos 
 
            'Create the enumerator.
            Dim ConnInfoEnum As ConnectionInfoEnumerator =  connectionInfos.GetEnumerator() 
            Console.WriteLine("The collection contains the following values:")
            Dim i As Integer =  0 
            While (ConnInfoEnum.MoveNext()) &&(ConnInfoEnum.Current <> Nothing)
            Console.WriteLine("[{0}] {1}",i = Console.WriteLine("[{0}] {1}",i + 1
            End While
        End Sub
    End Class
End Namespace

サンプルの出力 :

The collection contains the following values:

[0] Connection Manager for Files

[1] Connection Manager for SQL Server Compact

[2] Connection Manager for Multiple Flat Files

[3] Connection Manager for ADO

[4] Connection Manager for ODBC

[5] Connection Manager for ADO.NET

[6] Connection Manager for OLE DB

[7] Connection Manager for Multiple Files

[8] Connection Manager for Flat Files

[9] Connection Manager for Analysis Services

[10] Connection Manager for FTP

[11] Connection Manager for HTTP

[12] Message Queue Connection Manager

[13] SMTP Connection Manager

[14] WMI Connection Manager