Export (0) Print
Expand All

SqlConnection.Open Method

Opens a database connection with the property settings specified by the ConnectionString.

Namespace:  System.Data.SqlClient
Assembly:  System.Data (in System.Data.dll)

public override void Open()

Implements

IDbConnection.Open()

ExceptionCondition
InvalidOperationException

Cannot open a connection without specifying a data source or server.

or

The connection is already open.

SqlException

A connection-level error occurred while opening the connection. If the Number property contains the value 18487 or 18488, this indicates that the specified password has expired or must be reset. See the ChangePassword method for more information.

The <system.data.localdb> tag in the app.config file has invalid or unknown elements.

ConfigurationErrorsException

There are two entries with the same name in the <localdbinstances> section.

The SqlConnection draws an open connection from the connection pool if one is available. Otherwise, it establishes a new connection to an instance of SQL Server.

NoteNote

If the SqlConnection goes out of scope, it is not closed. Therefore, you must explicitly close the connection by calling Close.

NoteNote

If you specify a port number other than 1433 when you are trying to connect to an instance of SQL Server and using a protocol other than TCP/IP, the Open method fails. To specify a port number other than 1433, include "server=machinename,port number" in the connection string, and use the TCP/IP protocol.

NoteNote

The .NET Framework Data Provider for SQL Server requires the Security permission with "Allows calls to unmanaged assemblies" enabled (SecurityPermission with SecurityPermissionFlag set to UnmanagedCode) to open a SqlConnection with SQL Debugging enabled.

The following example creates a SqlConnection, opens it, and displays some of its properties. The connection is automatically closed at the end of the using block.

private static void OpenSqlConnection(string connectionString)
{
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        connection.Open();
        Console.WriteLine("ServerVersion: {0}", connection.ServerVersion);
        Console.WriteLine("State: {0}", connection.State);
    }
}

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0, 1.1, 1.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Show:
© 2014 Microsoft