SqlConnection 构造函数 (System.Data.SqlClient)
如果给定包含连接字符串的字符串，则初始化 SqlConnection 类的新实例。
public:
SqlConnection(System::String ^ connectionString);
public SqlConnection (string connectionString);
new System.Data.SqlClient.SqlConnection : string -> System.Data.SqlClient.SqlConnection
Public Sub New (connectionString As String)
参数
connectionString
String
用于打开 SQL Server 数据库的连接。
例外
ArgumentException
提供的连接字符串参数验证失败ConnectionString。
示例
以下示例创建并打开 SqlConnection。
private static void OpenSqlConnection()
{
string connectionString = GetConnectionString();
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
Console.WriteLine("State: {0}", connection.State);
Console.WriteLine("ConnectionString: {0}",
connection.ConnectionString);
}
}
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;";
}
Private Sub OpenSqlConnection()
Dim connectionString As String = GetConnectionString()
Using connection As New SqlConnection(connectionString)
connection.Open()
Console.WriteLine("State: {0}", connection.State)
Console.WriteLine("ConnectionString: {0}", _
connection.ConnectionString)
End Using
End Sub
Private Function GetConnectionString() As String
' 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);Database=AdventureWorks;" _
& "Integrated Security=SSPI;"
End Function
注解
创建新的 实例 SqlConnection 时，读/写属性将设置为以下初始值，除非使用属性中的 ConnectionString 关联关键字专门设置它们。
属性
初始值
ConnectionString
connectionString
ConnectionTimeout
15
Database
空字符串 (“”)
DataSource
空字符串 (“”)
只能使用 ConnectionString 属性更改这些属性的值。 类 SqlConnection 提供用于创建和管理连接字符串内容的功能。
另请参阅
连接到数据源 (ADO.NET)
使用适用于 SQL Server 的 .NET Framework 数据提供程序
ADO.NET 概述
适用于