SqlConnectionStringBuilder.DataSource Property

Definition

获取或设置要连接到的 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
Public Property DataSource As String

Property Value

String

DataSource 属性的值,或者,如果未提供任何值,则为 String.EmptyThe value of the DataSource property, or String.Empty if none has been supplied.

Attributes

Exceptions

若要将值设置为 null,请使用 ValueTo set the value to null, use Value.

Examples

以下示例演示 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

Remarks

此属性与连接字符串内的“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.

Applies to

See also