Re: Should I use XML as a database for a standalone app?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Cor, Vijay, Cerebrus,

Thanks very much for your extremely helpful replies. The idea at least is
sound now I just need to work out how to do it. :0)

There seems to be a real lack of example code for winforms(non asp) xml for
vb.net, does anyone know of any good places where I can get some grounding
on this ?

Many thanks again

Jim

"Cor Ligthert [MVP]" <notmyfirstname@xxxxxxxxx> wrote in message
news:%236npvYrXGHA.5012@xxxxxxxxxxxxxxxxxxxxxxx
Jim,

Your question is exactly were AdoNet and datasets are made for.

There are more and more disconnected data in the world, think for that on
PDA, webservices, and more stuff.

Every Dataset, even in a PC connected in a network, works disconnected.
Therefore you can save it at any point to any media. For the last you need
to write it with the extra parameter "DiffGram" as long as you don't save
it, by instance on a PDA, you have the same effect of course.

Be aware that the writeXML does not check if the file already exist and if
that stops while writing (power failure) you will lost everything if you
don't make a procedure to prevent that. Therefore I advice you to create
at least a mechanisme as FileCurrent and FilePrevious.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataxmlwritemodeclasstopic.asp

I hope this helps,

Cor


"Jim Florence" <florence_james@xxxxxxxxxxx> schreef in bericht
news:xMCdnWchLp18E6DZRVnyiA@xxxxxxxxxxxx
Hi,

I've just started work on a project where I need to have a tool to allow
people to work offline and then sync data back to a main database when
they come back onshore.

It's a basic app that would allow people to enter timesheet data, record
maintenance on offshore kit and raise requisitions.

I had the idea of exporting the necessary data from the main database as
XML files, using these as a mini database and the writing a procedure to
take the data back in the files at the end of a job.

I've had a quick look at this and have bits working but before I go too
far down the path I was hoping for a sanity check. And any pointers as
how to handle the XML data best in windows forms/grids

Many Thanks

Jim Florence







.

Relevant Pages

  • Re: Delphis for CE?
    ... One choice is going to be language to program in, and the other will be database to store data with. ... We're also considering having either a PDA add-on that synchs with the desktop version, or a PDA stand-alone without desktop version. ... I am used to regular databases like Firebird, MSSQL etc so the easiest way to get used to it for me was to treat it like a searchable object stack. ... My latest experiment was creating a mongrel database class of my own using XML to load/save to file, and loading search criterion into datatableat run time. ...
    (borland.public.delphi.non-technical)
  • Re: Publishing Database data?
    ... >with either Firebird or the specific schema of our database. ... >from our database so that its easy to retrieve. ... Only using it, not writing it. ... Apache has several XML based DB access addons. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Should I use XML as a database for a standalone app?
    ... I use Datasets in the most of the samples where connection to a database is ... XML files, using these as a mini database and the writing a procedure to ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Looking for a simple way to exchange data
    ... Now I'm writing a PDA version ... get the data from the PDA into the desktop app, ... database after it's been reviewed on the desktop app. ... I have been thinking of using XML file instead of using SQL CE in the ...
    (microsoft.public.pocketpc.developer)
  • RE: importing access to sql ce
    ... I will copy a text file onto the PDA into a predefined location when the app starts if the file exsist delete all the records and import the new ones using file methods to read the text file and loop through and insert each record. ... or is there a simpler way, maybe using XML and a dataset? ... can a dataset or dataAdapter read xml from a file and then update that to a database? ...
    (microsoft.public.sqlserver.ce)