Data Access.

[Michaelk]

Hi, i'm building a VB.NET appl for my PDA, and need somewhere to store data that can be submitted and retreived through a windows form.
But i don't know where to start.
1. If i use a Access database, does my PDA HAVE to have access installed?
2. if i don't use Access, whats the next best solution?
3. What sort of code do i use to Add/Search a database?

Thanks, and i hope somone can help me

 

[Mykre]

I would use XML Files on the PDA and sync them on the servers end.

Or you could look at SQLServerCE, or a Webservice on the server and have your PDA Call the Webservice to retrive the data.

Mykre

 

[Michaelk]

Thanks

Hi, thanks for that.

If i use XML files, where do i start?
I'm totaly new to this aspect so i got no idea where to start. Are there any good examples or code samples out there?

Thanks,

 

[Paszt]

The compact framework doesn't support Windows CE Property Databases (.cdb - often known as Pocket Access) but Peter Foot at www.inthehand.com has a third party ADOCE wrapper for Pocket Access.

If you don't want a third party solution, I would take Mykre's advice.

 

[Michaelk]

Ok thanks, will have a look at it.

 

[Mykre]

The dataset functions can be used in the compact framework, so you would work with datarows and datatables as normal. Then use the dataset.writexml and dataset.readxml methods to store the data to a location. Also you can save and read the xml schema data by useing the dataset write and read xml schema functions.

This way you do not have to work with xml data directly and can treat the files like a flat file database system.

Mykre