DBProviderInfos.Contains Method

Returns a Boolean that indicates if the items in the collection can be accessed using indexing without throwing an exception.

命名空間: 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
  An object containing the name, description, or index of the object.

傳回值

A Boolean that indicates if the collection can be accessed by name, description, or index passed as the index parameter. A value of true indicates that the collection can be accessed using the syntax DBProviderInfos[index]. A value of false indicates that indexing cannot be used to retrieve items from the DBProviderInfos collection.

範例

The following code sample uses Contains method to print the name of the first item in the collection. The method returns a Boolean.

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

namespace DBProvInfos_GetEnum
{
    class Program
    {
        static void Main(string[] args)
        {
            Application app = new Application();
            DBProviderInfos dbprovInfos = app.DBProviderInfos;

            // Search for the MediaCatalogDB provider in the collection
            if (dbprovInfos.Contains(0))
                Console.WriteLine("The collection contains {0} provider", dbprovInfos[0].Name);
            else
                Console.WriteLine("The collection does not contain {0} provider", dbprovInfos[0].Name);
        }
    }
}

Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
 
Namespace DBProvInfos_GetEnum
    Class Program
        Shared  Sub Main(ByVal args() As String)
            Dim app As Application =  New Application() 
            Dim dbprovInfos As DBProviderInfos =  app.DBProviderInfos 
 
            ' Search for the MediaCatalogDB provider in the collection
            If dbprovInfos.Contains(0) Then
                Console.WriteLine("The collection contains {0} provider", dbprovInfos(0).Name)
            Else 
                Console.WriteLine("The collection does not contain {0} provider", dbprovInfos(0).Name)
            End If
        End Sub
    End Class
End Namespace

Sample Output:

The collection contains MediaCatalogDB OLE DB Provider provider

執行緒安全性

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.

平台

開發平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

目標平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

請參閱

參考

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