Could not load type 'System.Data.SqlServerCe.SqlCeConnection' from assembly 'System.Data.SqlServerCe

  • Thread starter Thread starter yogeshvc
  • Start date Start date
Y

yogeshvc

Hi,

I m new bie to VS 2005 pocket pc development. I m trying to connect to
SQL CE database which will be created locally and used locally by
pocket pc application and nothing to do with sql server 2005 database.

Added Reference - System.Data.SqlServerCe

Dim engine As New SqlCeEngine("Data Source = \My Documents\test.sdf")
engine.CreateDatabase()

Dim ssceconn As New SqlCeConnection("Data Source = \My
Documents\test.sdf")
ssceconn.Open()

Dim sqlCreateTable As SqlCeCommand = ssceconn.CreateCommand()
sqlCreateTable.CommandText = "CREATE TABLE People(people_id int
IDENTITY(0,1) PRIMARY KEY, f_name ntext, l_name ntext)"
sqlCreateTable.ExecuteNonQuery()

Dim sqlInsertRow As SqlCeCommand = ssceconn.CreateCommand()
sqlInsertRow.CommandText = "INSERT INTO People(f_name, l_name)
VALUES('John', 'Doe')"
sqlInsertRow.ExecuteNonQuery()
ssceconn.Close()

And along with this, I cannt see Microsoft SQL Server Mobile Edition
while adding datasource in my project.
Data | Add New Data Source.

Guys please guide me thr' this.

Yogesh
 
Back
Top