IDtsConnectionService.CreateConnection Method (String)
Creates a new connection using the connection type specified as a parameter.
Namespace: Microsoft.SqlServer.Dts.Runtime.Design
Assembly: Microsoft.SqlServer.Dts.Design (in Microsoft.SqlServer.Dts.Design.dll)
Syntax
'Declaration
Function CreateConnection ( _
connectionType As String _
) As ArrayList
'Usage
Dim instance As IDtsConnectionService
Dim connectionType As String
Dim returnValue As ArrayList
returnValue = instance.CreateConnection(connectionType)
ArrayList CreateConnection(
string connectionType
)
ArrayList^ CreateConnection(
String^ connectionType
)
abstract CreateConnection :
connectionType:string -> ArrayList
function CreateConnection(
connectionType : String
) : ArrayList
Parameters
- connectionType
Type: System.String
The type of connection you want to put in the array.
Return Value
Type: System.Collections.ArrayList
An ArrayList containing the collection of connections created. An empty collection is returned if an error occurs or if the user cancels the request.
Remarks
The implementation code can be written to provide a list of connections in the user interface for user convenience.
Examples
The following code example shows how to get the list of connection types when the service is a file connection.
// Service is a connection service.
IDtsConnectionService dtsConnectionService =
serviceProvider.GetService(typeof(IDtsConnectionService)) as
IDtsConnectionService;
ArrayList list = dtsConnectionService.CreateConnection(connectionType);
ConnectionManager cMgr = (ConnectionManager)list[0];