Editing XML lines using C#

Question

0.00/5 (No votes)

See more:

I’m still getting into the whole automation stuff and there are still areas that I am unfamiliar with – Today it turns out to be XML editing.
I haven’t worked much with XML files so I’m struggling slightly with what I’m trying to do.

I need to edit the 3 versions lines in the XML file, incrementing the version number of "PhoneVersion", "TabletVersion" & "DesktopVersion" by 1.

See XML below

<configuration>
  <appSettings>
    <add key="PhoneVersion" value="36.999.1" />
    <add key="TabletVersion" value="36.999.1" />
    <add key="DesktopVersion" value="36.999.1" />
    <add key="ToolsEnabledKey" value="tokolosheQA" />
    <add key="ToolsURL" value="" />
    <add key="DbCommandTimeOut" value="60" />
  </appSettings>
</configuration>

I haven’t had much luck actually reading or accessing the individual elements/attributes.

What I have tried:

This is what i have tried

XDocument doc = XDocument.Load(webconfig);

foreach (XElement add in doc.Descendants("add"))
 {
    string[] values = add.Attribute("value").Value.Split(new char[] { '.' });
    values[values.Length - 1] = (int.Parse(values[values.Length - 1]) + 1).ToString();
    add.SetAttributeValue("value", string.Join(".", values));
 }

Posted 13-Jul-18 0:24am

Member 11546646

Updated 13-Jul-18 6:40am

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Gerry Schmitz · Answer 1 · 2018-07-13T06:41:00

Solution 4

Use the "configuration manager" to manage "configuration settings":

ConfigurationManager.AppSettings Property (System.Configuration)[^]

Posted 13-Jul-18 6:41am

Gerry Schmitz

Member 11546646 · Answer 2 · 2018-07-13T03:34:00

SO AFTER TINKERING WITH SOME IDEAS YOU GAVE ME - THIS WORKED GUY!!

string newValue = string.Empty;
     XmlDocument xmlDoc = new XmlDocument();

     xmlDoc.Load(webconfig);

     XmlNode PhoneVersionNode =
     xmlDoc.SelectSingleNode("configuration/appSettings/add[@key='PhoneVersion']");
     PhoneVersionNode.Attributes[1].Value = "newValue";


     xmlDoc.Save(webconfig);

THANKS FOR THE HELP

Maciej Los · Answer 3 · 2018-07-13T02:17:00

Xml file does not contain lines! Xml[^] content is a set of nodes!

Try this:

C#

XDocument xdoc = XDocument.Load(webconfig);
var nodes = xdoc.Descendants("add")
	.Select(x=> new
	{
		NodeName = x.Name,
		Key = (string)x.Attribute("key").Value,
		Value = (string)x.Attribute("value").Value
	})
	.ToList();

Result:

NodeName  Key               Value
add       PhoneVersion      36.999.1 
add       TabletVersion     36.999.1 
add       DesktopVersion    36.999.1 
add       ToolsEnabledKey   tokolosheQA 
add       ToolsURL   
add       DbCommandTimeOut  60

to select single node:

C#

XElement singlenode = xdoc.Descendants("add")
	.Where(x=> (string)x.Attribute("key").Value == "DesktopVersion")
	.SingleOrDefault();

singlenode.Attribute("value").Value = "Bla bla bla";

//save changes
xdoc.Save(webconfig)

For further details about manipulating xml content, please see: XDocument Class (System.Xml.Linq)[^]

Leo Chapiro · Answer 4 · 2018-07-13T01:57:00

Solution 1

Try this, assuming your XML is in _strXml:

C#

using System.Xml;


XmlDocument oDom = new XmlDocument();
oDom.LoadXml(_strXml);

XmlNode oXmlNode = oDom.FirstChild; // node "configurartion"
oXmlNode = oXmlNode.FirstChild;     // node "appSettings"

foreach (XmlNode oNode in oXmlNode.ChildNodes)
{
    if (oNode.Attributes["key"].Value == "PhoneVersion")
        oNode.Attributes["value"].Value = "whatever";
    // ... and so long ...
}

Posted 13-Jul-18 1:57am

Leo Chapiro

Updated 13-Jul-18 1:59am

v3

Comments

Member 11546646 13-Jul-18 8:22am

So this makes perfect sense! However i keep getting an error

"CMLException was unhandled - Data at the root level is invalid. Line 1, position 1."

string webconfig = BuildLocation + "\\Web.config";

XmlDocument oDom = new XmlDocument();
oDom.LoadXml(webconfig);

XmlNode oXmlNode = oDom.FirstChild;
oXmlNode = oXmlNode.FirstChild;

foreach (XmlNode oNode in oXmlNode.ChildNodes)
{
if (oNode.Attributes["key"].Value == "PhoneVersion")
oNode.Attributes["value"].Value = "36.999.0.01";

}

Editing XML lines using C#

4 solutions

Solution 4

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0