Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

SqlCeConnection Constructor (String)

Initializes a new instance of the SqlCeConnection class with the specified connection string.

Namespace:  System.Data.SqlServerCe
Assembly:  System.Data.SqlServerCe (in System.Data.SqlServerCe.dll)
public SqlCeConnection(
	string connectionString
)

Parameters

connectionString
Type: System.String
The connection used to open the database.

When a new instance of SqlCeConnection is created, the read/write properties are set to the following initial values unless they are set specifically by using their associated keywords in the ConnectionString property.

Properties

Initial Value

ConnectionString

connectionString

DataSource

empty string ("")

You can change the value for these properties only by using the ConnectionString property.

The following example creates and opens a SqlCeConnection.

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


Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.