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


"Miliuccio" <(E-Mail Removed)> wrote in message
news:ubVw%(E-Mail Removed)...
>i load a DATASET with SQL2000 TABLE
>
> i am not able to UPDATE with SQLCE DATAADAPTER
>
>
> how to do?
>
>
>

and how to do the travase?



"Darren Shaffer" <(E-Mail Removed)> ha scritto nel
messaggio news:(E-Mail Removed)...
> 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
>
>
> "Miliuccio" <(E-Mail Removed)> wrote in message
> news:ubVw%(E-Mail Removed)...
> >i load a DATASET with SQL2000 TABLE
> >
> > i am not able to UPDATE with SQLCE DATAADAPTER
> >
> >
> > how to do?
> >
> >
> >
>
>

why don't you just use Remote Data Access to SQL 2000
to populate your data in SQL CE?

--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com


"Miliuccio" <(E-Mail Removed)> wrote in message
news:OSpp%23%(E-Mail Removed)...
> and how to do the travase?
>
>
>
> "Darren Shaffer" <(E-Mail Removed)> ha scritto nel
> messaggio news:(E-Mail Removed)...
>> 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
>>
>>
>> "Miliuccio" <(E-Mail Removed)> wrote in message
>> news:ubVw%(E-Mail Removed)...
>> >i load a DATASET with SQL2000 TABLE
>> >
>> > i am not able to UPDATE with SQLCE DATAADAPTER
>> >
>> >
>> > how to do?
>> >
>> >
>> >
>>
>>
>
>

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


"Darren Shaffer" <(E-Mail Removed)> ha scritto nel
messaggio news:(E-Mail Removed)...
> why don't you just use Remote Data Access to SQL 2000
> to populate your data in SQL CE?
>
> --
> Darren Shaffer
> .NET Compact Framework MVP
> Principal Architect
> Connected Innovation
> www.connectedinnovation.com
>
>
> "Miliuccio" <(E-Mail Removed)> wrote in message
> news:OSpp%23%(E-Mail Removed)...
> > and how to do the travase?
> >
> >
> >
> > "Darren Shaffer" <(E-Mail Removed)> ha scritto
nel
> > messaggio news:(E-Mail Removed)...
> >> 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
> >>
> >>
> >> "Miliuccio" <(E-Mail Removed)> wrote in message
> >> news:ubVw%(E-Mail Removed)...
> >> >i load a DATASET with SQL2000 TABLE
> >> >
> >> > i am not able to UPDATE with SQLCE DATAADAPTER
> >> >
> >> >
> >> > how to do?
> >> >
> >> >
> >> >
> >>
> >>
> >
> >
>
>