SqlConnectionStringBuilder.Item Property (String)


Gets or sets the value associated with the specified key. In C#, this property is the indexer.

Namespace:   System.Data.SqlClient
Assembly:  System.Data (in System.Data.dll)

public override object this[
	string keyword
] { get; set; }


Type: System.String

The key of the item to get or set.

Property Value

Type: System.Object

The value associated with the specified key.

Exception Condition

keyword is a null reference (Nothing in Visual Basic).


Tried to add a key that does not exist within the available keys.


Invalid value within the connection string (specifically, a Boolean or numeric value was expected but not supplied).

Because the SqlConnectionStringBuilder contains a fixed-size dictionary, trying to add a key that does not exist within the dictionary throws a KeyNotFoundException.

The following code, in a console application, creates a new SqlConnectionStringBuilder and adds key/value pairs to its connection string, using the Item property.

class Program
    static void Main()
        SqlConnectionStringBuilder builder = 
            new SqlConnectionStringBuilder();
        builder["Data Source"] = "(local)";
        builder["Integrated Security"] = true;
        builder["Initial Catalog"] = "AdventureWorks";

        // Overwrite the existing value for the Data Source value.
        builder["Data Source"] = ".";

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

.NET Framework
Available since 2.0
Return to top