I have a architecture question.

[Daren Hawes]

Hi,

I have a architecture question.

How would one structure an application along with a Pocket PC 2003
component
that work together to collect survey data.

My query is around the Sync and Data Holding parts.

I plan to use an XML file on the PPC as a survey template (Questions,
Question Types. I was planning to create a dataset on the PPC that will
hold result data.

On Sync or Internet Connection via GPRS , I was planning to Updating
back to
SQL Server.

Is this a good idea? Or should I write to a XML Answers table? Or even
original XML file to hold answers?

Is there also "On Connect To Internet" or "PPC Cradled" events in VS
2003?

Thanks Heaps

Daren

 

[Chris Tacke, eMVP]

I'd write to a SSCE database, then either replicate it back or use a Web
Service connection to push data into the DB.

-Chris

 

[Daren Hawes]

Thanks for that.

I have a few questions.

1. Is Sql CE free?
2. Can I add it to my installation project to install on PPC if not
already?

3. As the PPC is "Always On" as such, could I not replace the SQL CE
with a Dataset ?

Thanks Daren

 

[Chris Tacke, eMVP]

1. Is Sql CE free?
For use a just a local data store, yes.

2. Can I add it to my installation project to install on PPC if not
already?

Yes, the CABs are distributed with Studio, just like the CF.

3. As the PPC is "Always On" as such, could I not replace the SQL CE
with a Dataset ?

Not sure what "always on" has to do with it. If you arr never ends, then I
suppose you could, but that's a big risk. What if the user resets the
device? What if the OS needs memory and closes your app? You need some
form of storage. You can pull data from the DB into a DataSet.