ConnectionInfos.Contains(Object) Method

Reference

Definition

Namespace:: Microsoft.SqlServer.Dts.Runtime

Assembly:: Microsoft.SqlServer.ManagedDTS.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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.

public:
 bool Contains(System::Object ^ index);

public bool Contains (object index);

member this.Contains : obj -> bool

Public Function Contains (index As Object) As Boolean

Parameters

index: Object

The name, index, ID, or identity of the object in the collection to match.

Returns

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

Applies to