How to update node values in XML using C#

Question

I have to update an original XML file with modified values. Below is my sample XML file:

<request>
<facility>
<alternateIDs>
            <alternateID code="ALT8">11111111</alternateID>
            <alternateID code="ALT12">111111111</alternateID>
            <alternateID code="ALT">1111111111</alternateID>
            <alternateID code="ALT1">11111111</alternateID>
            <alternateID code="ALT9">11111111</alternateID>
            <alternateID code="ALT3">111111111</alternateID>
</alternateIDs>
</facility>
</request>

Now I want to look for alternateID code="ALT" and change its value to 00000000. My final file should look like:

<request>
<facility>
<alternateIDs>
            <alternateID code="ALT8">11111111</alternateID>
            <alternateID code="ALT12">111111111</alternateID>
            <alternateID code="ALT">00000000</alternateID>
            <alternateID code="ALT1">11111111</alternateID>
            <alternateID code="ALT9">11111111</alternateID>
            <alternateID code="ALT3">111111111</alternateID>
</alternateIDs>
</facility>
</request>

How can I achieve this using XElement and XAttributes? I am not familiar with XML and C#. Any help is appreciated!

MistaGoustan · Accepted Answer · 2017-01-09 21:47:08Z

3

Got it!

public static void ReplaceCode()
     {
        var root = new XmlDocument();
         root.Load(@"C:\data.xml");

        foreach (XmlNode e in root.GetElementsByTagName("alternateID"))
        {
            if (e.Attributes["code"].Value.Equals("ALT"))
            {
                e.FirstChild.Value = "00000000"; // FirstChild because the inner node is actually the inner text, yeah XmlNode is weird.
                break;
            }
        }
        root.Save(@"C:\data.xml");
    }

Ask me anything about it and I can clarify. :)

answered Jan 9, 2017 at 21:47

MistaGoustan

3561 gold badge7 silver badges21 bronze badges

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

5 Comments

unicorn Over a year ago

thank you very much.. i got it!! :-).. only thing is once the value gets set to 0000000, i want to come out of the loop. but break here, actually take the control to the last line in the script and not immediate line after the loop.

MistaGoustan Over a year ago

Awesome! glad I could help. If you think it was good you should pay it forward and +1 the answer so others can see. :) I just went through this same problem so I just had to respond. hahahaha

MistaGoustan Over a year ago

The arrows on left side. Cheers.

unicorn Over a year ago

thanks!! I did it.. Somehow not able to save the changes in the file.. when I check root variable in debug mode values are still not updated

MistaGoustan Over a year ago

Check the file location, would your system have permission to edit a file there? Also is it a service ? That would mess it up for sure. I know how to fix that as well though

jdweng · Accepted Answer · 2017-01-09 21:03:33Z

0

Try this :

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Xml;
using System.Xml.Linq;

namespace ConsoleApplication34
{
    class Program
    {
        const string FILENAME = @"c:\temp\test.xml";
        static void Main(string[] args)
        {
            XDocument doc = XDocument.Load(FILENAME);

            XElement alt = doc.Descendants("alternateID").Where(x => (string)x.Attribute("code") == "ALT").FirstOrDefault();
            alt.Value = "00000000";

        }


    }


}

answered Jan 9, 2017 at 21:03

jdweng

34.5k3 gold badges17 silver badges19 bronze badges

1 Comment

unicorn Over a year ago

i cannot use linq XML. i am trying using XMLdocument, XML element but I am missing something..

MistaGoustan · Accepted Answer · 2017-01-09 21:29:42Z

0

Here is a non Linq way of doing it, although linq is much cleaner if you know how to read it.

public static void ReplaceCode()
     {
        var root = XElement.Load(@"C:\data.xml");
        foreach (var e in root.Descendants("alternateID"))
        {
            if (!e.Attribute("code").Value.Equals("ALT")) continue;
            e.Value = "00000000";
            break;
        }
        root.Save(@"C:\data.xml");
    }

answered Jan 9, 2017 at 21:29

MistaGoustan

3561 gold badge7 silver badges21 bronze badges

2 Comments

unicorn Over a year ago

for me somehow Xelement, Xdocument are disabled and i am only able to use XMLelement, XMLDocument etc.

MistaGoustan Over a year ago

Not a problem, my second answer that I just posted solves that. I'm keeping this answer up for others benefit. It goes nicely beside jdwengs sweet linq statement.

Collectives™ on Stack Overflow

How to update node values in XML using C#

3 Answers 3

5 Comments

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related