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


Show: