DbConnectionStringBuilder.ConnectionString 屬性
定義
重要
部分資訊涉及發行前產品，在發行之前可能會有大幅修改。 Microsoft 對此處提供的資訊，不做任何明確或隱含的瑕疵擔保。
取得或設定與 DbConnectionStringBuilder相關聯的連接字串。
public:
property System::String ^ ConnectionString { System::String ^ get(); void set(System::String ^ value); };public string ConnectionString { get; set; }member this.ConnectionString : string with get, setPublic Property ConnectionString As String屬性值
目前的連接字串，由包含在 DbConnectionStringBuilder中的鍵值對所建立。 預設值為空白字串。
例外狀況
已提供無效的連接字串參數。
範例
以下範例展示了該 ConnectionString 性質可能的行為。 範例：
透過一次加入一對鍵值對到空的 DbConnectionStringBuilder。
為實例屬性指派完整的連接字串ConnectionStringDbConnectionStringBuilder，並修改字串中的單一鍵值對。
為屬性 ConnectionString 指派任意一組鍵值對（即一個與連接字串完全不同的字串），並修改其中一個值。
會為該 ConnectionString 屬性指派一個無效的連接字串，以展示拋出的例外。
備註
這個範例包含密碼，用來示範如何 DbConnectionStringBuilder 處理連線字串。 我們建議您在應用程式中使用 Windows 認證。 如果必須使用密碼，請不要在申請中加入硬編碼密碼。
static void Main()
{
// Create a new DbConnctionStringBuilder, and add items
// to the internal collection of key/value pairs.
DbConnectionStringBuilder builder = new
DbConnectionStringBuilder();
builder.Add("Data Source", @"c:\MyData\MyDb.mdb");
builder.Add("Provider", "Microsoft.Jet.Oledb.4.0");
builder.Add("Jet OLEDB:System Database",
@"c:\MyData\Workgroup.mdb");
// Set up row-level locking.
builder.Add("Jet OLEDB:Database Locking Mode", 1);
// Display the contents of the connection string, which
// will now contain all the key/value pairs delimited with
// semicolons.
Console.WriteLine(builder.ConnectionString);
Console.WriteLine();
// Clear the DbConnectionStringBuilder, and assign a complete
// connection string to it, to demonstrate how
// the class parses connection strings.
builder.Clear();
builder.ConnectionString =
"Data Source=(local);Initial Catalog=AdventureWorks;"
+ "Integrated Security=SSPI";
// The DbConnectionStringBuilder class has parsed the contents,
// so you can work with any individual key/value pair.
builder["Data Source"] = ".";
Console.WriteLine(builder.ConnectionString);
Console.WriteLine();
// Because the DbConnectionStringBuilder class doesn't
// validate its key/value pairs, you can use this class
// to store any semicolon-delimited list. The following
// snippet places an arbitrary string into the ConnectionString
// property, changes one of the values, and then displays the
// resulting string.
builder.Clear();
builder.ConnectionString =
"Value1=10;Value2=20;Value3=30;Value4=40";
builder["Value2"] = 25;
Console.WriteLine(builder.ConnectionString);
Console.WriteLine();
builder.Clear();
try
{
// Assigning an invalid connection string
// throws an ArgumentException.
builder.ConnectionString = "xxx";
}
catch (ArgumentException)
{
Console.WriteLine("Invalid connection string.");
}
}
Sub Main()
' Create a new DbConnctionStringBuilder, and add items
' to the internal collection of key/value pairs.
Dim builder As New DbConnectionStringBuilder()
builder.Add("Data Source", "c:\MyData\MyDb.mdb")
builder.Add("Provider", "Microsoft.Jet.Oledb.4.0")
builder.Add("Jet OLEDB:System Database",
"c:\MyData\Workgroup.mdb")
' Set up row-level locking.
builder.Add("Jet OLEDB:Database Locking Mode", 1)
' Display the contents of the connection string, which
' will now contain all the key/value pairs delimited with
' semicolons.
Console.WriteLine(builder.ConnectionString)
Console.WriteLine()
' Clear the DbConnectionStringBuilder, and assign a complete
' connection string to it, to demonstrate how
' the class parses connection strings.
builder.Clear()
builder.ConnectionString =
"Data Source=(local);Initial Catalog=AdventureWorks;" &
"Integrated Security=SSPI"
' The DbConnectionStringBuilder class has parsed the contents,
' so you can work with any individual key/value pair.
builder("Data Source") = "."
Console.WriteLine(builder.ConnectionString)
Console.WriteLine()
' Because the DbConnectionStringBuilder class doesn't
' validate its key/value pairs, you can use this class
' to store any semicolon-delimited list. The following
' snippet places an arbitrary string into the ConnectionString
' property, changes one of the values, and then displays the
' resulting string.
builder.Clear()
builder.ConnectionString =
"Value1=10;Value2=20;Value3=30;Value4=40"
builder("Value2") = 25
Console.WriteLine(builder.ConnectionString)
Console.WriteLine()
builder.Clear()
Try
' Assigning an invalid connection string
' throws an ArgumentException.
builder.ConnectionString = "xxx"
Catch ex As ArgumentException
Console.WriteLine("Invalid connection string.")
End Try
Console.WriteLine()
Console.WriteLine("Press Enter to finish.")
Console.ReadLine()
End Sub
備註
此屬性回傳一個以分號分隔的鍵值對清單，這些鍵/值對儲存在由 維護的 DbConnectionStringBuilder集合中。 每對包含鍵與值，中間以等號分隔。 以下範例說明了典型的連接串。
"Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=AdventureWorks;Data Source=(local)"
資料提供者可能會期待每個連接字串屬性有特定的鍵值與值。 這些數值會被個別記錄。 該 DbConnectionStringBuilder 類別不會驗證與其連接字串相關的鍵值對，但繼承自其的類別可以。
ConnectionString這個DbConnectionStringBuilder類別的特性通常作為一種機制，用來建立和解析以分號分隔的鍵值對清單，這些鍵值對並以等號分隔。 它不提供針對連接字串的驗證或其他支援。 如果你將項目加入 DbConnectionStringBuilder 收藏 ConnectionString ，屬性也會反映變更。 如果你為屬性指派值 ConnectionString ，它 DbConnectionStringBuilder 會嘗試用分號和等號分隔符解析該值。
