Share via


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

ConnectionString

empty string ("")

DataSource

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");

See Also

Reference

SqlCeConnection Class

SqlCeConnection Members

SqlCeConnection Overload

System.Data.SqlServerCe Namespace