Share via


ConnectionInfos.Contains Method

Returns a Boolean that indicates whether the ConnectionInfo items in the ConnectionInfos collection can be accessed by using the name, index, ID, or identity parameter as the index.

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

Syntax

'Declaration
Public Function Contains ( _
    index As Object _
) As Boolean
'Usage
Dim instance As ConnectionInfos
Dim index As Object
Dim returnValue As Boolean

returnValue = instance.Contains(index)
public bool Contains(
    Object index
)
public:
bool Contains(
    Object^ index
)
member Contains : 
        index:Object -> bool 
public function Contains(
    index : Object
) : boolean

Parameters

  • index
    Type: System.Object
    The name, index, ID, or identity of the object in the collection to match.

Return Value

Type: System.Boolean
true indicates that you can retrieve the item using the syntax ConnectionInfos[index]; false indicates that indexing cannot be used to retrieve items from the ConnectionInfos collection.

Examples

The following example shows a search of the collection for the connection "DTS Connection Manager for Files". The name used in the search is the name returned in the Name property.

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;

namespace ConnInfosTest
{
    class Program
    {
        static void Main(string[] args)
        {
            Application dtsApplication = new Application();
            ConnectionInfos connectionInfos = dtsApplication.ConnectionInfos;

            // Search for the File connection in the collection
            if (connectionInfos.Contains("DTS Connection Manager for Files"))
                Console.WriteLine("The collection contains the FILE connection");
            else
                Console.WriteLine("The collection does not contain the FILE connection");
            Console.WriteLine();
        }
    }
}
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
 
Namespace ConnInfosTest
    Class Program
        Shared  Sub Main(ByVal args() As String)
            Dim dtsApplication As Application =  New Application() 
            Dim connectionInfos As ConnectionInfos =  dtsApplication.ConnectionInfos 
 
            ' Search for the File connection in the collection
            If connectionInfos.Contains("DTS Connection Manager for Files") Then
                Console.WriteLine("The collection contains the FILE connection")
            Else 
                Console.WriteLine("The collection does not contain the FILE connection")
            End If
            Console.WriteLine()
        End Sub
    End Class
End Namespace

Sample Output:

The collection contains the FILE connection