How to change an attribute in XML C#

Question

I have tried several methods, none of which appear to work...

You can see the different methods I have tried by taking a look at the commented lines of code, but I am able to get the attribute fine, and newIndex is updated properly, but then when I go to change the attribute called count it doesn't do anything.

XmlElement reports = (XmlElement)doc.SelectSingleNode("//Reports");
XmlAttribute reportCount = (XmlAttribute)doc.SelectSingleNode("//Reports/@count");
int count = Convert.ToInt32(reportCount.Value);
newIndex = count + 1;
//doc.DocumentElement.SetAttribute("count", "\"" + newIndex.ToString() + "\"");
//reportCount.Value = newIndex.ToString();
reports.SetAttribute("count", newIndex.ToString());

XML File

<?xml version="1.0" encoding="utf-8"?>
<Reports count="1"><!--this count should be equal to the last id-->
  <Report id="1">
    <Workbook>APG0214.xlsx</Workbook>
    <Filepath>\\fileserver\homeshares\POS Reports</Filepath>
  </Report>
  <Report id="2">
    <Workbook>CBM0214.xlsx</Workbook>
    <Filepath>\\fileserver\homeshares\POS Reports</Filepath>
  </Report>
</Reports>

Any help is appreciated!

Have you looked at this post yet? stackoverflow.com/questions/367730/… — Josh Jay
– Josh Jay, Commented Apr 7, 2014 at 20:55

Selman Genç · Accepted Answer · 2014-04-07 20:55:01Z

2

I'm not familiar with old XML API but I would use LINQ to XML in this case:

var xmlDocument = XDocument.Load("path");
var reports = xmlDocument.Root;
var maxId = reports
            .Elements("Report")
            .Select(x => (int)x.Attribute("id"))
            .Max();
reports.Attribute("count").SetValue(maxId);
xmlDocument.Save("path");

answered Apr 7, 2014 at 20:55

Selman Genç

102k15 gold badges126 silver badges193 bronze badges

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

1 Comment

Adjit Over a year ago

Not the reason for the issue, but I do like the answer syntax.

a'' · Accepted Answer · 2014-04-07 21:03:19Z

0

You probably forgot about

doc.Save("your_path_to_xml_file")

at the end ;)

answered Apr 7, 2014 at 21:03

a''

2,3922 gold badges24 silver badges34 bronze badges

1 Comment

Adjit Over a year ago

I hate myself for asking this question now... this method of mine is for adding an element to the XML file, and I add it using XPath, but I get this using a regular XmlDocument, so in the end I save the XPath version, but not the XmlDocument version. And I knew this, and was about to say you were wrong, but then I had an epiphany :P

Martin Costello · Accepted Answer · 2014-04-07 20:55:52Z

0

Just use the following:

reportCount.Value = newIndex.ToString(CultureInfo.InvariantCulture);

and the save the XML back to the original file (or somewhere new).

answered Apr 7, 2014 at 20:55

Martin Costello

11.1k5 gold badges67 silver badges78 bronze badges

2 Comments

Adjit Over a year ago

what is the cultureInfo for?

Martin Costello Over a year ago

Ensures that you write the value consistently regardless of any localisation settings on the executing OS. Not putting it would generate an FxCop warning.

Collectives™ on Stack Overflow

How to change an attribute in XML C#

XML File

3 Answers 3

1 Comment

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

XML File

3 Answers 3

1 Comment

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related