Saving New Data into XML using C#

Question

Hi,

I've an application that needs saving data from datagrid into an XML file.

Currently, it is working only half way coz the file keeps saving the data to the original file. Which means, it is appended to the bottom of the .XML but it repeats the root element.

I'ld like to eliminate this problem, but couldn't go about it.

Any suggestion?

I think my current code is a little low-level, so hopefully, there's a more efficient method.

Thanks,

Ika

P.S: I've inserted screen shots of the before and after of the .xml file when new data is inserted.

******

Sam Hobbs · Answer

Thank you for the clarification. Then in your program you can read the existing data in, then add the new data, then write that out. If you write the data out to the same file that you read from, then call dispose on the stream you use to read the data; otherwise you might get a sharing violation trying to write to the file. I don't know how to do that using XmlTextWriter. You might need to convert your code to use XmlText. I suggest converting your code to use XmlDocument. Load the XML using XmlDocument.Load and then get the root using GetElementsByTagName. Then append the new data to the XmlNodeList. You can get more help with XmlDocument by searching the articles in this web site for XmlDocument; go to this web site's home page and search the articles from there.

Sam Hobbs · Answer

And thank you. Your appreciation is gratifying.

Ika AJ · Answer

Dear Sam, worked like a charm!!! Thks soooooooo much! Appreciate it loads!

Ika AJ · Answer

Hi Sam, Actually, I do want it to be appended rather than flushing the whole document again and again when saved, which is why I used .Append. However, I want it to be appended before the root tag ends. And not repeat the end root tag repeatedly. Thanks Ika

Sam Hobbs · Answer

Did this help you? If it did, then please check the box indicating it did.

Sam Hobbs · Answer

In your program, when you create Stream xmlFile, you use Append for the mode, so of course the data will be appended. If you don't want it to be appended, then don't use Append.