data transfer between pc and pocket pc

[hs]

Hi Everyone

I want to write an application where a user connects a pda device to a pc
using a data cable(or something else).
Then clicks a button on my application which makes a connection to a
database on my pc (or a another computer) and downloads data onto the
device's database (say sqlserver CE).
How do i do this.

2) the user will collect information on the device (populating the sqlserver
ce database) and then will want to transfer this data back on to the pc
database. Is there a way i can transfer the data.

any help/ideas is appreciated
hs

 

[Paul G. Tobey [eMVP]]

1) (I guess; you don't have a #1) You might do this with a Web Service
running on the PC, which would send the data that your device wants. Of
course, you'll need a program on the device to access the Web Service and do
something with the data.

2) You could do this with RDA, if the device is normally connected, whether
via radio or cellular, to the network. That is, the data would not have to
be stored locally and you could simply send a new row to the SQL Server
database on the server each time new data was collected on the device. If
that won't work, you could try to do this with replication. This is a big
topic and you'll need to read up on it and when it would work and not work
before going much further.

Paul T.