Solved

Storing without a database

Posted on 2007-11-19
8
155 Views
Last Modified: 2010-04-23
I want to store data without using a database backend.  I might want to port the application to a handheld at sometime in the future so I need to store the data on the desktop in a way that would be compatable.  I have only done programming using the jet engine in the past and have no idea where to start.  Thanks
0
Comment
Question by:Moed
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 15

Expert Comment

by:spprivate
ID: 20315508
The best  option is to have it in XML files.

Satheesh
0
 
LVL 15

Assisted Solution

by:Solar_Flare
Solar_Flare earned 50 total points
ID: 20315513
if the data is quite simple then you can save a dataset to XML and load it back again really easily.

just call the datasets ReadXML and writeXML methods passing in a filename, this wil lsimply persist the dataset to the XML file and read it back again.
0
 
LVL 15

Assisted Solution

by:spprivate
spprivate earned 200 total points
ID: 20315516
http://www.w3schools.com/xml/xml_savedata.asp
 a good example of storing data in XML
0
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

 
LVL 2

Author Comment

by:Moed
ID: 20315556
Well, it seems like xml is the solution of choice.  In a database program I am used to multiple tables linked with common information.  Does it work the same way in xml.  How do you add, edit, delete? Are sql statements used to retrieve the selected information?  Is there a good reference book?
0
 
LVL 18

Expert Comment

by:jcoehoorn
ID: 20315680
Look at Microsoft SQL Server Compact Edition.  It's upward compatible with full sql server and it was designed originally for use on PocketPC.  You may not *need* a database yet, but as your application grows you'll be happy you designed with a relational data model in mind from the beginning.
0
 
LVL 2

Author Comment

by:Moed
ID: 20315735
jcoehoorn
Is Microsoft sql server compact edition similar to access in usage.  I would rather continue using what I'm used to if possible?
0
 
LVL 15

Expert Comment

by:spprivate
ID: 20315921
in XML you can use XPath and XQuery to mess around with the data.
As far as Compact edition it is pretty much like SQL except for that it is a lighter one.
http://www.microsoft.com/sql/editions/compact/default.mspx
0
 
LVL 18

Accepted Solution

by:
jcoehoorn earned 250 total points
ID: 20315982
Yes, it's similar in usage.  The difference it that it uses SQL Server syntax rather than access syntax, but there aren't that many differences.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
get row value in vb.net 4 17
VB.net and sql server 4 45
location of a form 2 25
Need syntax help building hyperlink 2 25
This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question