Re: dataset sql2000 sqlce

Tech-Archive recommends: Speed Up your PC by fixing your registry

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" <emiliocella@xxxxxxxxxx> wrote in message
news:OSpp%23%23KyFHA.2212@xxxxxxxxxxxxxxxxxxxxxxx
> and how to do the travase?
>
>
>
> "Darren Shaffer" <darrenshaffer@xxxxxxxxxxxxxxxxxxxxxxxxx> ha scritto nel
> messaggio news:ODxThTGyFHA.3864@xxxxxxxxxxxxxxxxxxxxxxx
>> 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" <emiliocella@xxxxxxxxxx> wrote in message
>> news:ubVw%23fDyFHA.1032@xxxxxxxxxxxxxxxxxxxxxxx
>> >i load a DATASET with SQL2000 TABLE
>> >
>> > i am not able to UPDATE with SQLCE DATAADAPTER
>> >
>> >
>> > how to do?
>> >
>> >
>> >
>>
>>
>
>


.

Relevant Pages

  • Re: SQLExpress Merge Replication
    ... >> I am trying to get a SQLExpress client to merge replicate with SQL Server ... >> Darren Shaffer ... >> ..NET Compact Framework MVP ... >> Principal Architect ...
    (microsoft.public.sqlserver.replication)
  • Re: How to detect which ListView item user clicks?
    ... Darren Shaffer .NET Compact Framework MVP ... Connected Innovation www.connectedinnovation.com ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Problem with CF2.0 and form.show
    ... >> ..NET Compact Framework MVP ... >> Principal Architect ... >> Connected Innovation ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Error Inserting Data
    ... ..NET Compact Framework MVP ... Principal Architect ... Connected Innovation ...
    (microsoft.public.sqlserver.ce)
  • Re: Why my app Close!!!
    ... ..NET Compact Framework MVP ... Principal Architect ... Connected Innovation ...
    (microsoft.public.pocketpc.developer)