DbConnectionStringBuilder.ContainsKey(String) 메서드

정의

네임스페이스:

System.Data.Common

어셈블리:

System.Data.Common.dll

Source:

DbConnectionStringBuilder.cs

DbConnectionStringBuilder에 특정 키가 들어 있는지 여부를 확인합니다.

public:
 virtual bool ContainsKey(System::String ^ keyword);

public virtual bool ContainsKey (string keyword);

abstract member ContainsKey : string -> bool
override this.ContainsKey : string -> bool

Public Overridable Function ContainsKey (keyword As String) As Boolean

매개 변수

keyword

String

DbConnectionStringBuilder에서 찾을 수 있는 키입니다.

반환

Boolean

지정된 키가 있는 항목이 DbConnectionStringBuilder에 포함되어 있으면 true이고, 포함되지 않으면 false입니다.

예외

ArgumentNullException

keyword이 null 참조(Visual Basic의 경우 Nothing)인 경우

예제

static void Main()
{
    DbConnectionStringBuilder builder = new DbConnectionStringBuilder();
    builder.Add("Provider", "Provider=Microsoft.Jet.OLEDB.4.0");
    builder.Add("Data Source", "C:\\ThisExcelWorkbook.xls");
    builder.Add("Extended Properties", "Excel 8.0;HDR=Yes;IMEX=1");

    // Displays the values in the DbConnectionStringBuilder.
    Console.WriteLine("Contents of the DbConnectionStringBuilder:");
    Console.WriteLine(builder.ConnectionString);

    // Searches for a key.
    if (builder.ContainsKey("Data Source"))
    {
        Console.WriteLine("The collection contains the key \"Data Source\".");
    }
    else
    {
        Console.WriteLine("The collection does not contain the key \"Data Source\".");
    }
    Console.ReadLine();
}

Sub Main()
    ' The following code example searches for an element in a 
    ' DbConnectionStringBuilder.
    Dim builder As New DbConnectionStringBuilder
    builder.Add("Provider", "Provider=Microsoft.Jet.OLEDB.4.0")
    builder.Add("Data Source", "C:\ThisExcelWorkbook.xls")
    builder.Add("Extended Properties", "Excel 8.0;HDR=Yes;IMEX=1")

    ' Displays the values in the DbConnectionStringBuilder.
    Console.WriteLine("Contents of the DbConnectionStringBuilder:")
    Console.WriteLine(builder.ConnectionString)

    ' Searches for a key.
    If builder.ContainsKey("Data Source") Then
        Console.WriteLine("The collection contains the key ""Data Source"".")
    Else
        Console.WriteLine("The collection does not contain the key ""Data Source"".")
    End If
    Console.ReadLine()
End Sub

이 코드의 결과는 다음과 같습니다.

Contents of the DbConnectionStringBuilder:
provider="Provider=Microsoft.Jet.OLEDB.4.0";data
source=C:\MyExcel.xls;extended
properties="Excel 8.0;HDR=Yes;IMEX=1"
The collection contains the key "Data Source".

추가 정보

• ADO.NET의 연결 문자열
• ADO.NET 개요