Newbie question.....

[Kiwiyb]

Sorry...under pressure for quick information from the boss so have limited time to research this myself...apologies.

Have virtually no knowledge of ADO.net and reading and updating data from XML files.

If I have an XML file containing a large table full of data...to update one record in the XML file, am i correct in assuming that i need to read the whole table into a Dataset, update that one record and then write back out to the file?

Also, if i have related tables, should i have these tables in seperate XML files and read them into seperate datasets and somehow perform a relational query...or should the full schema of the database and tables all be in the one xml file?

Sorry, these questions may not make a lot of sense, but i hope someone can help me here!! Is it appropriate to use xml files in this way...or are they essentially read-only??

Stew

 

[apffal]

A question about XML :
Is it possible to use XML for querying a database and displaying its results, without using a local or remote server ?

 

[JontyMC]

Kiwiyb: XML files are not databases, they are text files. You can load an XML file into a variable in the same way as you would a text file. In the case of .Net, you can load it into an XmlDocument object, then manipulate it with the library of XML methods and objects, then save.

XML is structured data, so if you have data that is related, the XML should reflect this, otherwise why are you using XML?

apffal: for a new question, use a new thread and explain your question more.

Jon

"Asteroids do not concern me, Admiral. I want that ship, not excuses.