Adding data to an existing xml file

Question

I am using the follwing syntax to add data to already existing xml file in the following way:

XmlTextReader Reader = new XmlTextReader("ServerPaths.xml");
        DataSet dsNewList = new DataSet();
        dsNewList.ReadXml(Reader);
        Reader.Close();
        DataTable dt = dsNewList.Tables[0];
        dt.Rows.Add(txtNewServerPath.Text);
        dt.WriteXml("ServerPaths.xml",false);

But, i was getting error at last line as:

System.IO.IOException was unhandled
          Message=The process cannot access the file 'C:\Documents and Settings\590000\my documents\visual studio 2010\Projects\EasyDeployer\EasyDeployer\bin\Debug\ServerPaths.xml' because it is being used by another process

Please help in solving this error. or is there any other way to do this?

My xml file looks like this:

<?xml version="1.0" encoding="utf-8" ?>
<ServerList>
<ServerPath>C:\\Avinash\\Dev1</ServerPath>
<ServerPath>C:\\Avinash\\Dev1</ServerPath>
</ServerList>

I just wanted to add new serverpath..

Maybe try Reader.Flush();

Bobby
– Bobby

2013-09-20 13:56:23 +00:00
Commented Sep 20, 2013 at 13:56 — Bobby
– Bobby, Commented Sep 20, 2013 at 13:56
Do you have the file open while you're running this?

Anthony
– Anthony

2013-09-20 13:57:24 +00:00
Commented Sep 20, 2013 at 13:57 — Anthony
– Anthony, Commented Sep 20, 2013 at 13:57
Reader.Flush() is not available

Sai Avinash
– Sai Avinash

2013-09-20 13:58:48 +00:00
Commented Sep 20, 2013 at 13:58 — Sai Avinash
– Sai Avinash, Commented Sep 20, 2013 at 13:58
No..The file is closed.

Sai Avinash
– Sai Avinash

2013-09-20 13:59:41 +00:00
Commented Sep 20, 2013 at 13:59 — Sai Avinash
– Sai Avinash, Commented Sep 20, 2013 at 13:59
Try Reader.Dispose() after you're done reading the file.

gitsitgo
– gitsitgo

2013-09-20 14:00:46 +00:00
Commented Sep 20, 2013 at 14:00 — gitsitgo
– gitsitgo, Commented Sep 20, 2013 at 14:00

Wolfwyrd · Accepted Answer · 2013-09-20 14:10:54Z

3

You could also try adding XmlNode's to the xml document like this:

XmlDocument xd = new XmlDocument();
xd.Load("ServerPaths.xml");

XmlNode rootNode = xd.DocumentElement;
XmlNode serverPathNode = xd.CreateElement("ServerPath");
serverPathNode.InnerText = txtNewServerPath.Text; // Your value

rootNode.AppendChild(serverPathNode);

xd.Save("ServerPaths.xml");

edited Sep 20, 2013 at 14:10

Wolfwyrd

15.9k5 gold badges50 silver badges68 bronze badges

answered Sep 20, 2013 at 14:06

Jasper

5343 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Jasper Over a year ago

Do you have the XML document open somewhere else? Like an editor?

Sai Avinash Over a year ago

The file is in the debug folder of the applciation, is it creating any problem?

Sai Avinash Over a year ago

No,it is completely closed

Jasper Over a year ago

It's somehow locked, are you using this file in any other way in your code? And maybe not closing the connection? You could also try using another file.

Sai Avinash Over a year ago

Got..it..Thanks. yes it was opened in other part of code..now i closed it by using Reader.close()

|

Collectives™ on Stack Overflow

Adding data to an existing xml file

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related