Help on XML application

  • Thread starter Thread starter Chris Jackson
  • Start date Start date
C

Chris Jackson

Hi all - im loving my new Axim X3i

I'm now wanting to develop on it -
I have VS.NET 2003 and im looking for sample projects or on-line examples
of:

using an XML file as a datasource to populate text fields on the form - then
allow a user to modify the data in the text field - and save the data back
to the XML file with a "Save" button...

VB.NET or C# is fine
I prefer C#

This will get me started in development.

Next question - for performance reasons - is it better to use a CSV file ,
XML file or a .cdb (access) file for record counts of about 1000?

Thanks.
 
For 1,000 records xml will probably have all the performance you need. Of
course the actual performance will depend on many things like the size of
those 1000 records (obviosuly 1000 records with two integer fields isn't the
same as 1000 records with 100 large string fields). I've handled stuff with
2000-4000 records and 12 fields msot of which were strings and performance
after the initial load is indistinguishable from using SQL CE for instance
and if you use a dataset, after the load the data is in memory so it'll be
the same overhead regardless of how you load it.

Also, XML is wayyyy easier to navigate and deal with, so I think it's
probably the preferred way to go based on the info you provided.

HTH,

Bill
 
Chris,

My personal experience is using CSV to populate a dataset (which can be used
to bind to grid text box etc) is much faster the loading XML with ReadXML
method. You can get a CSV dataadapter from http://www.opennetcf.org/csv.asp,
which I found very easy to use and for about 4000 records (2 int field and 1
sting field with 25 characters) I found it is about atleast 2 times faster
the XML.

Also regarding the performance it depends whether you need to hold all 1000
records in memory all the time or load them based on a condition. If you
need to hold all 1000 records in memory, as William said, it doesn't matter
whether you use XML or any database. But if you can query and have say 50
records at a time, I would recommend using SQLCE.

Best Regards,
Y. Sivaram
 
Back
Top