共用方式為


DBProviderInfos.Contains 方法

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 (在 Microsoft.SqlServer.ManagedDTS.dll 中)

語法

'宣告
Public Function Contains ( _
    index As Object _
) As Boolean
'用途
Dim instance As DBProviderInfos 
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

參數

  • index
    型別:System.Object
    An object containing the name, description, or index of the object.

傳回值

型別:System.Boolean
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

請參閱

參考

DBProviderInfos 類別

Microsoft.SqlServer.Dts.Runtime 命名空間