SqlConnectionStringBuilder.DataSource 属性
定义
获取或设置要连接到的 SQL Server 实例的名称或网络地址。Gets or sets the name or network address of the instance of SQL Server to connect to.
public:
property System::String ^ DataSource { System::String ^ get(); void set(System::String ^ value); };
public string DataSource { get; set; }
[System.ComponentModel.TypeConverter(typeof(System.Data.SqlClient.SqlConnectionStringBuilder/SqlDataSourceConverter))]
public string DataSource { get; set; }
member this.DataSource : string with get, set
[<System.ComponentModel.TypeConverter(typeof(System.Data.SqlClient.SqlConnectionStringBuilder/SqlDataSourceConverter))>]
member this.DataSource : string with get, set
Public Property DataSource As String
属性值
为 DataSource 属性的值,或者,如果未提供任何值,则为 String.Empty。The value of the DataSource property, or String.Empty if none has been supplied.
- 属性
例外
示例
以下示例演示 SqlConnectionStringBuilder 类将“Data Source”连接字符串键的同义词转换为已知键:The following example demonstrates that the SqlConnectionStringBuilder class converts synonyms for the "Data Source" connection string key into the well-known key:
using System.Data.SqlClient;
class Program
{
static void Main()
{
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(
"Network Address=(local);Integrated Security=SSPI;" +
"Initial Catalog=AdventureWorks");
// Display the connection string, which should now
// contain the "Data Source" key, as opposed to the
// supplied "Network Address".
Console.WriteLine(builder.ConnectionString);
// Retrieve the DataSource property.
Console.WriteLine("DataSource = " + builder.DataSource);
Console.WriteLine("Press any key to continue.");
Console.ReadLine();
}
}
Imports System.Data.SqlClient
Module Module1
Sub Main()
Dim builder As _
New SqlConnectionStringBuilder( _
"Network Address=(local);Integrated Security=SSPI;" & _
"Initial Catalog=AdventureWorks")
' Display the connection string, which should now
' contain the "Data Source" key, as opposed to the
' supplied "Network Address".
Console.WriteLine(builder.ConnectionString)
' Retrieve the DataSource property:
Console.WriteLine("DataSource = " & builder.DataSource)
Console.WriteLine("Press any key to continue.")
Console.ReadLine()
End Sub
End Module
注解
此属性与连接字符串内的“Data Source”、“server”、“address”、“addr”和“network address”键相对应。This property corresponds to the "Data Source", "server", "address", "addr", and "network address" keys within the connection string. 无论在提供的连接字符串中提供了哪些值,由创建的连接字符串 SqlConnectionStringBuilder 将使用众所周知的 "数据源" 键。Regardless of which of these values has been supplied within the supplied connection string, the connection string created by the SqlConnectionStringBuilder will use the well-known "Data Source" key.