Get child node value from xml using xpath

Question

    <Demo_Test>
      <Step ID="1">
        <ACTION>Point</ACTION>
        <CLASS_ID>dfsfsdf</CLASS_ID>
      </Step>
    <Step ID="2">
        <ACTION>Point</ACTION>
        <CLASS_ID>Avkddd</CLASS_ID>
      </Step>
    <Step ID="3">
        <ACTION>Point</ACTION>
        <CLASS_ID>afsasfa</CLASS_ID>
      </Step>
   <Step ID="4">
        <ACTION>SubAction</ACTION>
        <CLASS_ID>afsasfa</CLASS_ID>
      </Step>
    </Demo_Test>

I want to modify value of "CLASS_ID" having "Action" node value is "Point" For that i have written below code but doesn't work

 string l_xPath = "//Step/ACTION["Point"]";
 XmlNodeList l_nodeList = l_doc.SelectNodes(l_xPath);

maybe [this](https://stackoverflow.com/questions/13081415/xml-how-to-grab-child-nodes-in-single-node-and-not-whole-document#answer-13081458) will help you — styx, Jun 27 '18 at 09:55

score 0 · Answer 1 · answered Jun 27 '18 at 10:06

Using xml linq I put results into a dictionary

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

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

            Dictionary<int, string> dict = doc.Descendants("Step")
                .Where(x => (string)x.Element("ACTION") == "Point")
                .GroupBy(x => (int)x.Attribute("ID"), y => (string)y.Element("CLASS_ID"))
                .ToDictionary(x => x.Key, y => y.FirstOrDefault());

        }

    }

}

I wasn't sure what was the best method to create results. A dictionary you can modify the value without any issues. If your output is gong to be the same xml format I can modify code to enumerate through the elements and modify the value. — jdweng, Jun 27 '18 at 10:12

score 0 · Answer 2 · answered Jun 27 '18 at 10:09

You can use this:

        var l_nodeList = l_doc.SelectNodes("//Step[ACTION='Point']");
        foreach (XmlNode item in l_nodeList)
        {
            Console.WriteLine(item.SelectSingleNode("CLASS_ID").InnerText);
        }

But I like jdweng's answer better

score 0 · Answer 3 · answered Jun 27 '18 at 10:10

at first you need an object like this:

using System;
using System.Xml.Serialization;
using System.Collections.Generic;
namespace Xml2CSharp
{
    [XmlRoot(ElementName="Step")]
    public class Step {
        [XmlElement(ElementName="ACTION")]
        public string ACTION { get; set; }
        [XmlElement(ElementName="CLASS_ID")]
        public string CLASS_ID { get; set; }
        [XmlAttribute(AttributeName="ID")]
        public string ID { get; set; }
    }

    [XmlRoot(ElementName="Demo_Test")]
    public class Demo_Test {
        [XmlElement(ElementName="Step")]
        public List<Step> Step { get; set; }
    }

}

then you can deserilze xml with this method:

public static T XmlDeserializer<T>(string xmlString)
{
    var instance = default(T);
    var xmlSerializer = new XmlSerializer(typeof(T));
    using (var stringreader = new StringReader(xmlString))
        instance = (T)xmlSerializer.Deserialize(stringreader);

    return instance;
}

then just use it like this:

var result = XmlDeserializer<Demo_Test >("your xml string here");
var l_nodeList =result.Step[0].CLASS_ID;

@Jaques, actually code you need is only one line - deserialize. OP not mentioned about where and how solution will be used. You can write xpath or xml linq query for every small task, but just creating one-two classes which represents schema will makes xpath redundant. — Fabio, Jun 27 '18 at 11:05

score 0 · Answer 4 · answered Jun 27 '18 at 10:26

This solution achieved using XPath

XmlDocument d = new XmlDocument();
            d.Load(@"C:\Users\Desktop\test.xml");

            XPathNavigator nav = d.CreateNavigator();
            XPathExpression exp;
            exp = nav.Compile("//Step[ACTION='Point']");
            XPathNodeIterator iterator = nav.Select(exp);
            var a = d.SelectNodes("//Step[ACTION='Point']");

            while (iterator.MoveNext())
            {
                Console.WriteLine(iterator.Current.SelectSingleNode("CLASS_ID").Value);
            }

Get child node value from xml using xpath

4 Answers4