Export (0) Print
Expand All

SqlCeConnection.Close Method

Closes the connection to the data source. This is the preferred method of closing any open connection.

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

public override void Close()

Implements

IDbConnection.Close()

The Close method rolls back any pending transactions and then releases the connection. If Close is called while handling a StateChange event, no additional StateChange events are fired.

An application can call Close more than one time. No exception is generated.

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


Show:
© 2014 Microsoft