dataset sql2000 sqlce

  • Thread starter Thread starter Miliuccio
  • Start date Start date
M

Miliuccio

i load a DATASET with SQL2000 TABLE

i am not able to UPDATE with SQLCE DATAADAPTER


how to do?
 
you want a System.Data.SqlClient SqlDataAdapter,
NOT a System.Data.SqlServerCe SqlDataAdapter
if you are working with SQL2000.

You cannot fill a dataset with a SqlClient DataAdapter from SQL2000
and then turn around and call update on a SqlServerCe DataAdapter.

--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com
 
and how to do the travase?



Darren Shaffer said:
you want a System.Data.SqlClient SqlDataAdapter,
NOT a System.Data.SqlServerCe SqlDataAdapter
if you are working with SQL2000.

You cannot fill a dataset with a SqlClient DataAdapter from SQL2000
and then turn around and call update on a SqlServerCe DataAdapter.

--
Darren Shaffer
.NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com
Click to expand...
 
to use rda i must manage an iis server and replicate a sql2000db
i'd like to access directly to main db without any other configuration
 
Back
Top