Help! SqlCeDataAdapter

I am trying to take a dataset returned from my web
service and merge it with the local SQL Server CE
table "Route_Sheets". I can't even get it to compile. I
get errors like da doesn't contain a definition
for "Fill",dbadaptor not referenced. This is what I
have. Please help. Thanks.


using System.Data;
using System.Xml;
using System.Data.SqlServerCe;

DataSet dsRemote = new DataSet();
dsRemote = ws.GetRouteSheet(2);

SqlCeConnection conn = new SqlCeConnection
(LocalStorage.ConnectionString);
SqlCeDataAdapter adapter = new SqlCeDataAdapter();
adapter.SelectCommand = new SqlCeCommand("SELECT *
FROM ROUTE_SHEETS", conn);
adapter.Fill(dsRemote);
.

Peter
Wed Oct 29 14:38:01 CST 2003

Add a reference to the System.Data.Common assembly to your application this
contains the DbDataAdapter class from which SqlCeDataAdapter is derived.
Step by step walkthrough of adding a reference here if you are not sure:-
http://www.inthehand.com/forums/viewtopic.php?t=128

Peter

--
Peter Foot
Windows Embedded MVP
OpenNETCF.org Senior Advisor
www.inthehand.com | www.opennetcf.org

"Phill" <anonymous@discussions.microsoft.com> wrote in message
news:0c8201c39e24$731604e0$a401280a@phx.gbl...
> I am trying to take a dataset returned from my web
> service and merge it with the local SQL Server CE
> table "Route_Sheets". I can't even get it to compile. I
> get errors like da doesn't contain a definition
> for "Fill",dbadaptor not referenced. This is what I
> have. Please help. Thanks.
>
>
> using System.Data;
> using System.Xml;
> using System.Data.SqlServerCe;
>
> DataSet dsRemote = new DataSet();
> dsRemote = ws.GetRouteSheet(2);
>
> SqlCeConnection conn = new SqlCeConnection
> (LocalStorage.ConnectionString);
> SqlCeDataAdapter adapter = new SqlCeDataAdapter();
> adapter.SelectCommand = new SqlCeCommand("SELECT *
> FROM ROUTE_SHEETS", conn);
> adapter.Fill(dsRemote);
> .
>
>