OdbcConnectionStringBuilder.ContainsKey(String) Method

Definition

Namespace:

System.Data.Odbc

Assembly:

System.Data.Odbc.dll

Package:

System.Data.Odbc v9.0.0

Source:

OdbcConnectionStringbuilder.cs

Determines whether the OdbcConnectionStringBuilder contains a specific key.

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

public override bool ContainsKey (string keyword);

override this.ContainsKey : string -> bool

Public Overrides Function ContainsKey (keyword As String) As Boolean

Parameters

keyword

String

The key to locate in the OdbcConnectionStringBuilder.

Returns

Boolean

true if the OdbcConnectionStringBuilder contains an element that has the specified key; otherwise false.

Exceptions

ArgumentNullException

keyword is null (Nothing in Visual Basic).

Examples

The following example creates an OdbcConnectionStringBuilder instance, sets some of its properties, and then tries to determine whether various keys exist within the object by calling the ContainsKey method.

using System.Data.Odbc;

class Program
{
    static void Main()
    {
        OdbcConnectionStringBuilder  builder = new OdbcConnectionStringBuilder();
        builder.Driver = "Microsoft Visual FoxPro Driver";
        builder["SourceType"] = "DBC";

        // Keys that you have provided return true.
        Console.WriteLine(builder.ContainsKey("SourceType"));

        // Comparison is case insensitive.
        Console.WriteLine(builder.ContainsKey("sourcetype"));

        // Keys added by the provider return false. This method
        // only examines keys added explicitly.
        Console.WriteLine(builder.ContainsKey("DNS"));

        // Keys that do not exist return false.
        Console.WriteLine(builder.ContainsKey("MyKey"));

        Console.WriteLine("Press Enter to continue.");
        Console.ReadLine();
    }
}

Imports System.Data.Odbc    

Module Module1
  Sub Main()
    Dim builder As New OdbcConnectionStringBuilder()
    builder.Driver = "Microsoft Visual FoxPro Driver"
    builder("SourceType") = "DBC"

    ' Keys you have provided return true.
    Console.WriteLine(builder.ContainsKey("SourceType"))

    ' Comparison is case insensitive.
    Console.WriteLine(builder.ContainsKey("sourcetype"))

    ' Keys added by the provider return false. This method
    ' only examines keys added explicitly.
    Console.WriteLine(builder.ContainsKey("DNS"))

    ' Keys that do not exist return false.
    Console.WriteLine(builder.ContainsKey("MyKey"))

    Console.WriteLine("Press Enter to continue.")
    Console.ReadLine()
  End Sub
End Module

See also

• Connection String Builders
• Connection Strings in ADO.NET