Solved

Storing without a database

Posted on 2007-11-19
8
151 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
Comment Utility
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
Comment Utility
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
Comment Utility
http://www.w3schools.com/xml/xml_savedata.asp
 a good example of storing data in XML
0
 
LVL 2

Author Comment

by:Moed
Comment Utility
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
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 18

Expert Comment

by:jcoehoorn
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
Article by: Kraeven
Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

772 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now