ConnectionInfos.GetEnumerator Method

Returns a ConnectionInfoEnumerator that can iterate through the ConnectionInfos collection.

Namespace:  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

public ConnectionInfoEnumerator GetEnumerator()

The following code sample creates a ConnectionInfoEnumerator 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 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);
        }
    }
}

Sample Output:

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

Community Additions

ADD
Show: