Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

SqlConnection.DataSource Property

Definition

Namespace:
Microsoft.Data.SqlClient
Assembly:
Microsoft.Data.SqlClient.dll
Package:
Microsoft.Data.SqlClient v1.0.19269.1
Package:
Microsoft.Data.SqlClient v1.1.4
Package:
Microsoft.Data.SqlClient v2.0.1
Package:
Microsoft.Data.SqlClient v2.1.4
Package:
Microsoft.Data.SqlClient v3.0.1
Package:
Microsoft.Data.SqlClient v3.1.0
Package:
Microsoft.Data.SqlClient v4.0.1
Package:
Microsoft.Data.SqlClient v4.1.0
Package:
Microsoft.Data.SqlClient v5.0.0
Package:
Microsoft.Data.SqlClient v5.1.0
Package:
Microsoft.Data.SqlClient v5.2.0
Package:
Microsoft.Data.SqlClient v6.0.2
Package:
Microsoft.Data.SqlClient v6.1.3
Package:
Microsoft.Data.SqlClient v7.0.1
Source:
SqlConnection.cs
Source:
SqlConnection.cs
Source:
SqlConnection.cs
Source:
SqlConnection.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(); };
[System.ComponentModel.Browsable(true)]
public override string DataSource { get; }
public override string DataSource { get; }
[<System.ComponentModel.Browsable(true)>]
member this.DataSource : string
member this.DataSource : string
Public Overrides ReadOnly Property DataSource As String

Property Value

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

Attributes

Examples

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

using Microsoft.Data.SqlClient;

class Program1
{
 static void Mainx()
 {
 string s = GetConnectionString();

 OpenSqlConnection(s);
 Console.ReadLine();
 }

 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);
 }
 }

 static private string GetConnectionString()
 {
 // To avoid storing the connection string in your code, 
 // you can retrieve it from a configuration file, using the 
 // System.Configuration.ConfigurationSettings.AppSettings property 
 return "Data Source=(local);Initial Catalog=AdventureWorks;"
 + "Integrated Security=SSPI;";
 }
}

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

using System;
using System.Data;
using Microsoft.Data.SqlClient;

class Program1
{
 static void Main()
 {
 string s = GetConnectionString();

 OpenSqlConnection(s);
 Console.ReadLine();
 }

 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);
 }
 }

 static private string GetConnectionString()
 {
 // To avoid storing the connection string in your code, 
 // you can retrieve it from a configuration file, using the 
 // System.Configuration.ConfigurationSettings.AppSettings property 
 return "Data Source=(local);Initial Catalog=AdventureWorks;"
 + "Integrated Security=SSPI;";
 }
}

Applies to