How to read XML Nodes in XML using c#.net

Question

I have a XML file like below:

<report timestamp="3201" reportVersion="2" request="3981135340">
<question timedOut="false" time="3163" attempts="2" correct="true" id="13"> 
<answer status="attempt"> 
<radioButton correct="false" value="true" id="17" /> 
</answer> 
<answer status="correct"> 
<radioButton correct="true" value="true" id="15" /> 
</answer> 
</question> 
</report>

I want to read the child nodes based on 'status' attribute of 'answer' node.

Answer 1

Use XmlReader (fastest but forward only), XDocument (LINQ to XML) or XmlDocument. See the examples in the msdn documentation.

Answer 2

Using LINQ to XML:

using System.Xml.Linq;

var doc = XDocument.Parse(xml); // or XDocument.Load()
var elements = from e in doc.Descendants("answer")
               where e.Attribute("status").Value == "attempt"
               select e;

// elements will be IEnumerable<XElement>

Answer 3

Use XmlDocument and XPath:

XmlDocument document = new XmlDocument();
//here you should load your xml for example with document.Load();
XmlNodeList nodes = document.SelectNodes("/report/question/answer[@status = 'correct']/radioButton");

Just modify the XPath to your needs.

Answer 4

try this one..

foreach (XmlNode xnode in xdoc.SelectNodes("report/question/answer"))
    {
        if (xnode.Attributes.GetNamedItem("status").Value == "correct")
        {
            string value = xdoc.SelectSingleNode("report/question/answer[@status='correct']/radioButton").Attributes.GetNamedItem("id").Value;

        }
        if (xnode.Attributes.GetNamedItem("status").Value == "attempt")
        {
            string value = xdoc.SelectSingleNode("report/question/answer[@status='attempt']/radioButton").Attributes.GetNamedItem("id").Value;
        }
    }