can anyone help me out? totally stuck

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