SqlConnection.DataSource 屬性
重要
部分資訊涉及發行前產品,在發行之前可能會有大幅修改。 Microsoft 對此處提供的資訊,不做任何明確或隱含的瑕疵擔保。
取得要連線的 SQL Server 執行個體名稱。
public:
virtual property System::String ^ DataSource { System::String ^ get(); };
public:
property System::String ^ DataSource { System::String ^ get(); };
C#
public override string DataSource { get; }
C#
[System.Data.DataSysDescription("SqlConnection_DataSource")]
public string DataSource { get; }
C#
[System.ComponentModel.Browsable(true)]
public override string DataSource { get; }
member this.DataSource : string
[<System.Data.DataSysDescription("SqlConnection_DataSource")>]
member this.DataSource : string
[<System.ComponentModel.Browsable(true)>]
member this.DataSource : string
Public Overrides ReadOnly Property DataSource As String
Public ReadOnly Property DataSource As String
要連線之 SQL Server 實例的名稱。 預設值為空字串。
- 屬性
下列範例會建立 , SqlConnection 並顯示其部分唯讀屬性。
C#
private static void OpenSqlConnection(string connectionString)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
Console.WriteLine("ServerVersion: {0}", connection.ServerVersion);
Console.WriteLine("DataSource: {0}", connection.DataSource);
}
}
Private Sub OpenSqlConnection(ByVal connectionString As String)
Using connection As New SqlConnection(connectionString)
connection.Open()
Console.WriteLine("ServerVersion: {0}", connection.ServerVersion)
Console.WriteLine("DataSource: {0}", connection.DataSource)
End Using
End Sub
注意
如果 的 SqlConnection 連接字串 為 “context connection=true”,則DataSource屬性會傳回 null
。
產品 | 版本 |
---|---|
.NET | Core 1.0, Core 1.1, 6 (package-provided), 7 (package-provided), 8 (package-provided), 9 (package-provided), 10 (package-provided) |
.NET Framework | 1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1 |
.NET Standard | 2.0 (package-provided) |