SqlConnectionStringBuilder.Item[String] Property

Definition

获取或设置与指定的键关联的值。Gets or sets the value associated with the specified key. 在 C# 中,此属性为索引器。In C#, this property is the indexer.

public:
 virtual property System::Object ^ default[System::String ^] { System::Object ^ get(System::String ^ keyword); void set(System::String ^ keyword, System::Object ^ value); };
public override object this[string keyword] { get; set; }
member this.Item(string) : obj with get, set
Default Public Overrides Property Item(keyword As String) As Object

Parameters

keyword
String

要获取或设置的项的键。The key of the item to get or set.

Property Value

Object

与指定键关联的值。The value associated with the specified key.

Exceptions

keyword 为空引用(在 Visual Basic 中为 Nothing)。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).

Examples

以下代码在控制台应用程序中新建一个 SqlConnectionStringBuilder,并使用 Item[] 属性将键/值对添加到其连接字符串中。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(builder.ConnectionString);
        Console.WriteLine();
        Console.WriteLine("Press Enter to continue.");
        Console.ReadLine();
    }
}
Module Module1
    Sub Main()
        Dim builder As New SqlConnectionStringBuilder
        builder.Item("Data Source") = "(local)"
        ' Item is the default property, so 
        ' you needn't include it in the reference.
        builder("Integrated Security") = True
        builder.Item("Initial Catalog") = "AdventureWorks"

        ' Overwrite the existing value for the Data Source value.
        builder.Item("Data Source") = "."

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

Remarks

由于 SqlConnectionStringBuilder 包含固定大小的字典,因此如果尝试添加的键不在字典中,则会引发 KeyNotFoundExceptionBecause the SqlConnectionStringBuilder contains a fixed-size dictionary, trying to add a key that does not exist within the dictionary throws a KeyNotFoundException.

Applies to

See also