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)
Syntax
'Declaration
Public Function GetEnumerator As ConnectionInfoEnumerator
'Usage
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
Return Value
Type: Microsoft.SqlServer.Dts.Runtime.ConnectionInfoEnumerator
A ConnectionInfoEnumerator for the ConnectionInfos collection.
Examples
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);
}
}
}
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
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