Export (0) Print
Expand All

SqlCeConnection.Open Method

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

Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)

public override void Open ()
public void Open ()
public override function Open ()

Exception typeCondition
InvalidOperationException

The connection is already open.

SqlCeException

A connection-level error occurred while opening the connection.

This method establishes a new connection to the data source.

w3y07zxz.note(en-us,VS.90).gifNote:
If the SqlCeConnection goes out of scope, it is not closed. You must explicitly close the connection by calling Close or Dispose.


The following example creates a SqlCeConnection, opens it, executes a query, and then closes the connection.

SqlCeConnection conn = null;

try
{
    conn = new SqlCeConnection("Data Source = MyDatabase.sdf; Password ='<pwd>'");
    conn.Open();

    SqlCeCommand cmd = conn.CreateCommand();
    cmd.CommandText = "INSERT INTO Customers ([Customer ID], [Company Name]) Values('NWIND', 'Northwind Traders')";

    cmd.ExecuteNonQuery();
}
finally
{
    conn.Close();
}

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

Windows Vista, Windows Mobile 5.0, Windows XP Professional with Service Pack 2 (SP2), Windows Server 2003, Windows Mobile 2003 for Pocket PC, Windows CE 5.0
Version Information
.NET Framework and NET Compact Framework
Supported in 3.5
.NET Framework
Supported in 3.0
.NET Compact Framework and .Net Framework
Supported in 2.0

Show:
© 2014 Microsoft