Поделиться через


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.

Пространство имен: Microsoft.SqlServer.Dts.Runtime
Сборка: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

Синтаксис

'Декларация
Public Function Contains ( _
    index As Object _
) As Boolean
public bool Contains (
    Object index
)
public:
bool Contains (
    Object^ index
)
public boolean Contains (
    Object index
)
public function Contains (
    index : Object
) : boolean

Параметры

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

Возвращаемое значение

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.

Пример

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

Синхронизация потоков

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Платформы

Платформы разработки

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

Целевые платформы

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

См. также

Справочник

ConnectionInfos Class
ConnectionInfos Members
Microsoft.SqlServer.Dts.Runtime Namespace