0 out of 1 rated this helpful - Rate this topic

SqlCeConnection.Open Method

Visual Studio 2010

Other Versions

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)

Syntax

C++

JScript

[SecurityCriticalAttribute]
[SecurityTreatAsSafeAttribute]
public override void Open()

Implements

IDbConnection.Open()

Exceptions

Exception	Condition
InvalidOperationException	The connection is already open.
SqlCeException	A connection-level error occurred while opening the connection.

Remarks

This method establishes a new connection to the data source.

Note
If the SqlCeConnection goes out of scope, it is not closed. You must explicitly close the connection by calling Close or Dispose.

Examples

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

Reference

SqlCeConnection Class

System.Data.SqlServerCe Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)