Modify existing Element in XMLfile

Question

I got an existing XML file

 <Customer>
  <PrivateCustomer>
    <Adresse>USA</Adresse>
    <Phone>12345678</Phone>
    <Name>John</Name>
    <Age>20</Age>
    <Sex>Man</Sex>
    <Contract> <Contract/>
  </PrivateCustomer>
  <PrivateCustomer>
    <Adresse>Canada</Adresse>
    <Phone>12345678</Phone>
    <Name>Peter</Name>
    <Age>20</Age>
    <Sex>Woman</Sex>
    <Contract> <Contract/>
  </PrivateCustomer>
 <Customer>

In my C# GUI i can select the Names from the xml file in a ComboBox. I want to modify my XML file, where i can change the content of the "Contract" Element where the Name Element = "John".

Ex.

<Customer>
      <PrivateCustomer>
        <Adresse>USA</Adresse>
        <Phone>12345678</Phone>
        <Name>John</Name>
        <Age>20</Age>
        <Sex>Man</Sex>
        <Contract>Sold<Contract/>
      </PrivateCustomer>
      <PrivateCustomer>
        <Adresse>Canada</Adresse>
        <Phone>12345678</Phone>
        <Name>Peter</Name>
        <Age>20</Age>
        <Sex>Woman</Sex>
        <Contract> <Contract/>
      </PrivateCustomer>
     <Customer>

How can i do it?

XDocument is a great place to start. It realy easy to manipulate your dom with linq statements. Have a look at the ReplaceWith functionality, it allows you to replace a node or XElement with a new one. — Spook Kruger, Feb 24 '14 at 15:29

score 1 · Answer 1 · edited May 23 '17 at 12:23

1

Try Modify XML existing content in C#, the accepted answer has an example where you can search for an element and alter it's value.

XmlDocument doc = new XmlDocument();
doc.Load("D:\\build.xml");
XmlNode root = doc.DocumentElement;
XmlNode myNode = root.SelectSingleNode("descendant::books");
myNode.Value = "blabla";
doc.Save("D:\\build.xml");

edited May 23 '17 at 12:23

Community

1
1

answered Feb 24 '14 at 15:25

user3256944 salutes Monica

774
1
12
27

Thanks Robert for expanding on my answer – user3256944 salutes Monica Feb 24 '14 at 15:27

Selman Genç · Accepted Answer · 2014-02-24T15:38:11.390

0

To modify an existing element first get the selected name, for example in SelectedIndexChanged event of ComboBox the use LINQ to XML:

var selectedName = comboBox1.SelectedItem.ToString();
var xDoc = XDocument.Load("path");
var cust = xDoc.Descendants("PrivateCustomer")
           .FirstOrDefault(x => (string)x.Element("Name") == selectedName);

if(cust != null)
{
   // edit Customer
   cust.Element("Contract").Value = "some value..";
}
xDoc.Save("path");  // save the xml file

edited Feb 24 '14 at 15:38

answered Feb 24 '14 at 15:22

Selman Genç

100,147
13
119
184

This doesn't appear to do what the OP wants. – Robert Harvey Feb 24 '14 at 15:23
Thanks bro, you are simply Awesome :D – user3346509 Feb 24 '14 at 16:02

Modify existing Element in XMLfile

2 Answers2