Open Method
Collapse the table of content
Expand the table of content

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.

NoteNote

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


  • Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see .

Windows CE, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows XP Professional x64 Edition, Windows XP SP2

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

.NET Compact Framework

Supported in: 2.0, 1.0

Community Additions

ADD
Show:
© 2016 Microsoft