Open Method

OleDbConnection.Open Method ()

 

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

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

public override void Open()

Exception Condition
InvalidOperationException

The connection is already open.

OleDbException

A connection-level error occurred while opening the connection.

The OleDbConnection draws an open connection from the connection pool if one is available. Otherwise, it establishes a new connection to the data source. You can open more than one DataReader on a single OleDbConnection. If the OLEDB provider you use does not support more than one active DataReader on a single connection, the OLEDB provider implicitly opens an additional connection for each.

System_CAPS_noteNote

If the OleDbConnection goes out of scope, it is not closed. Therefore, you must explicitly close the connection by calling Close or Dispose, or using the connection within a Using statement.

.NET Framework
Available since 1.1
Return to top
Show:
© 2016 Microsoft