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)
Syntax
'Declaration
<SecurityCriticalAttribute> _
<SecurityTreatAsSafeAttribute> _
Public Overrides Sub Open
'Usage
Dim instance As SqlCeConnection
instance.Open()
[SecurityCriticalAttribute]
[SecurityTreatAsSafeAttribute]
public override void Open()
[SecurityCriticalAttribute]
[SecurityTreatAsSafeAttribute]
public:
virtual void Open() override
[<SecurityCriticalAttribute>]
[<SecurityTreatAsSafeAttribute>]
abstract Open : unit -> unit
[<SecurityCriticalAttribute>]
[<SecurityTreatAsSafeAttribute>]
override Open : unit -> unit
public override function Open()
Implements
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.
Dim conn As SqlCeConnection = Nothing
Try
conn = New SqlCeConnection("Data Source = MyDatabase.sdf; Password ='<pwd>'")
conn.Open()
Dim cmd As SqlCeCommand = conn.CreateCommand()
cmd.CommandText = "INSERT INTO Customers ([Customer ID], [Company Name]) Values('NWIND', 'Northwind Traders')"
cmd.ExecuteNonQuery()
Finally
conn.Close()
End Try
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();
}