SqlCeConnection Constructor
Initializes a new instance of the SqlCeConnection class.
Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in System.Data.SqlServerCe.dll)
Syntax
'Declaration
Public Sub New
'Usage
Dim instance As New SqlCeConnection()
public SqlCeConnection()
public:
SqlCeConnection()
new : unit -> SqlCeConnection
public function SqlCeConnection()
Remarks
When a new instance of SqlCeConnection is created, the read/write properties are set to the following initial values unless they are specifically set by using their associated keywords in the ConnectionString property.
Properties |
Initial Value |
|---|---|
empty string ("") |
|
empty string ("") |
You can change the value for these properties only by using the ConnectionString property.
Examples
The following example creates and opens a SqlCeConnection.
Dim conn As New SqlCeConnection()
' Set some connection string properties e.g.:
'
conn.ConnectionString = _
"Persist Security Info = False; Data Source = 'SalesData.sdf';" & _
"Password = '<password>'; File Mode = 'shared read'; " & _
"Max Database Size = 256; Max Buffer Size = 1024"
conn.Open()
' You can change the database while preserving
' the orignal connection options
'
conn.ChangeDatabase("SupportData.sdf")
SqlCeConnection conn = new SqlCeConnection();
// Set some connection string properties e.g.:
//
conn.ConnectionString =
"Persist Security Info = False; Data Source = 'SalesData.sdf';" +
"Password = '<password>'; File Mode = 'shared read'; " +
"Max Database Size = 256; Max Buffer Size = 1024";
conn.Open();
// You can change the database while preserving
// the orignal connection options
//
conn.ChangeDatabase("SupportData.sdf");