SqlConnection.DataSource Property

Reference

Definition

Namespace:: System.Data.SqlClient

Assembly:: System.Data.SqlClient.dll

Assembly:: System.Data.dll

Package:: System.Data.SqlClient v4.9.0

Source:: System.Data.SqlClient.notsupported.cs

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Gets the name of the instance of SQL Server to which to connect.

public:
 virtual property System::String ^ DataSource { System::String ^ get(); };

public:
 property System::String ^ DataSource { System::String ^ get(); };

public override string DataSource { get; }

[System.Data.DataSysDescription("SqlConnection_DataSource")]
public string DataSource { get; }

[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

Property Value

String

The name of the instance of SQL Server to which to connect. The default value is an empty string.

Attributes: DataSysDescriptionAttribute BrowsableAttribute

Examples

The following example creates a SqlConnection and displays some of its read-only properties.

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

Remarks

Note

The DataSource property returns null if the connection string for the SqlConnection is "context connection=true".

Applies to

Product	Versions
.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)

Share via