Re: can anyone help me out? totally stuck

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



RDA or merge replication fit the bill. Both are well documented.

If you must use a web service for this, then it's going to be all custom
work. You'll have to handle push, pull and conflict resolution.


--
Chris Tacke - Embedded MVP
OpenNETCF Consulting
Managed Code in the Embedded World
www.opennetcf.com
--


"Mike" <whyme@xxxxxxxxx> wrote in message
news:%23mvG2vSfHHA.1312@xxxxxxxxxxxxxxxxxxxxxxx
Ok, here is the situation and I can't find anything such as books,
snippets, etc, online to save my life.
here is what I need to do:

1) I have a web service that I need to use to pull my data from my Sql
Server (source).
2) The web service is returning a dataset
3) I then need to take that dataset and insert it into the database on my
Pocket PC. I do not want to delete the tables all the time, I want to
create the database once and only insert the records from the dataset. I
need this due to a worker can have work in his queue that he hasn't gotten
to yet and I don't want to delete that every time, I only want to 'update'
the database on the mobile device with new records only.

4) I then need to 'push'/merge, etc, the data from the handheld to the Sql
Server source database.
5) I have several tables in the Sql CE database, and everything I'm seeing
online is using only 1 table, I need to pull from several tables, and push
several tables.

Someone has had to done this before? Any help is greatly appricated.

the lack of documentation on mobile development is redicolous in my
opinon.





.



Relevant Pages

  • One Web Service updates SQL, the other cant
    ... One Web Service can access and update the database via ADO ... Is there a exclusive, read-only, permissions setting that I've missed ... The problem is simply the second Web Service can't write to SQL, ...
    (microsoft.public.vb.database.ado)
  • Re: Databases and web services
    ... I came across vulnerabilities related to SQL injection and what I ... Sorry, mopkn, but I suspect you will have to adjust your question. ... whether a web service or any other type can access a database ...
    (comp.databases.theory)
  • Re: ADP PICK database connect to SQL
    ... > all database programming outside of using PHP with mysql. ... > importing them into sql. ... directly with ADP support for details on how to call their web service ...
    (comp.databases.pick)
  • Re: Desperate for help with SQL CE
    ... Query analyser is included in the sqlce.dev.devicetype.cab file which you'll ... I'm very familiar with SQL server, ... > database, or sync up, or anything like that. ... The documentation said where to find Query Analyzer...and it ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Number of SQL Server logins
    ... Tibor Karaszi, SQL Server MVP ... > Can't find documentation, but master.dbo.syslogins does not use a counter. ... > In userdatabase.dbo.sysusers, uid is a smallint, so 32'767 would be the> limit per database. ... > "Oscar" wrote: ...
    (microsoft.public.sqlserver.server)