Synchronising XML files/databases on PDA

[Christiane]

Hi there,

I am new to developing applications with .net compact
framework. I would like to develop an application for
inventories, which has to communicate with a DB2 on AS/400.
It has to get current inventory list from there and write
back to the db. The idea is, that the synchronisation
works with help of a cradle on the PC in the LAN.
What is the best way to set up the connection? Is it
possible to use PocketPC operating system at all or does
it have to be WinCE for using SQL CE and ADO.net. Is it
possible to transfer XML files and hold all the data in
XML-files on the PDA? How would synchronisation with plain
XML files work??
So you see there are a lot of buzzwords and confusion.
Does anybody have any experiences? Any best practices???
Thanks very much in advance
Christiane

 

[Bill Sonia]

Sql CE will work with PocketPC. Regarding xml files; what
I've done in the past is to use XmlTextReader to read xml
to a dataset and use the dataset WriteXml method to write
xml to a file. Datasets are handy containers for pulling
or pushing recordsets to/from a Sql Ce database and to
manipulate the data as you see fit while it's resident in
your application.

hth,

Bill Sonia
www.achaiasolutions.com

 

[William Ryan]

I have posted on Devbuzz b/c I do this sort of thing a lot. Using
DataSet.WriteXML and DataSet.ReadXML has saved me a lot of headaches b/c my
particular app has multiple SQL Servers and Access Databases and I use DTS
to Snyc things up regularly....
http://forums.devbuzz.com/m.asp?m=24285&mpage=1&p=5&tmode=1&smode=1&key=

You may find it worthwhile..

Cheers,

Bill

 

[Christiane Duethorn]

Thanks very much for your posts. I'm now creating an xml file which I
want to synchronise with the mobile device.
Is there another way to do this apart from using ActiveSync? Is there a
way to change the default directory ActiveSync uses ? Can I write my own
program to tranfer this file when my device is connected?

Thanks very much
Christiane