Data Access.

Michaelk

Well-known member
Joined
Jun 3, 2004
Messages
58
Location
Australia
Programming Experience
3-5
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

Active member
Joined
Jun 14, 2004
Messages
28
Location
Australia
Programming Experience
3-5
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
 

Paszt

Staff member
Joined
Jun 3, 2004
Messages
1,500
Location
Raleigh, NC - USA
Programming Experience
Beginner
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.
 
Last edited:

Mykre

Active member
Joined
Jun 14, 2004
Messages
28
Location
Australia
Programming Experience
3-5
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
 
Top Bottom