XML Element Navigation using the Indexer, accessing childnodes by indexing from parents.

Question

0.00/5 (No votes)

See more:

I have a nested XML document a sample of which is as follows:

XML

<?xml version="1.0" encoding="utf-8"?>
<root>
  <contact>
    <adr3 />
    <city>Alicante</city>
    <time_in_spain>
      <departed_UK>1999-09-12</departed_UK>
      <residency>2010-06-21</residency>
    </time_in_spain>
    <oap>true</oap>
    <case>
      <docs_posted>2011-06-21</docs_posted>
      <completion>2011-06-21</completion>
      <payment_recieved_uk>
        <date_received>2011-06-21</date_received>
        <transfer_date>2011-06-21</transfer_date>
      </payment_recieved_uk>
    </case>
  </contact>
</root>

I want to access the childnodes such as <date_received></date_received> by means of the indexer. I am accessing Contact.ChildNodes such as <adr3> by means of contactnode["adr3"].InnerText, but it will not work when I try either of: contactnode["date_received"].InnerText or contactnode["//date_received"].InnerText or contactnode["case/payment_receieved_uk/date_received"].InnerText. How, then, can I access these child nodes. Restructuring the database IS and option but the structure helps with management in other ways; I would prefer just to get the qualified name correct or access by some other means.

Posted 23-Jun-10 2:42am

watson128

Updated 5-Jul-10 0:10am

v3

Add a Solution

1 solution

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)

Bigdeak · Answer 1 · 2010-06-23T22:09:00

I hope this class will help you, try XmlStuff.GetXmlStuffFromPath( string path ) for you Xml file.
Well there is the technique to get all Nodes from the Xml.

MSIL

class XmlStuff
    {
        public string adr3 { get; set; }
        public string city { get; set; }
        public string departed_UK { get; set; }
        public string residency { get; set; }
        public bool oap { get; set; }
        public string docs_posted { get; set; }
        public string completion { get; set; }
        public string date_received { get; set; }
        public string transfer_date { get; set; }
        public static XmlStuff GetXmlStuffFromPath(string path)
        {
            XmlStuff xmlStuff = new XmlStuff();
            XmlDocument xmlDocument = new XmlDocument();
            xmlDocument.Load(path);
            foreach (XmlNode xmlNode in xmlDocument.ChildNodes)
            {
                switch (xmlNode.Name)
                {
                    case "root":
                        foreach (XmlNode rootChildNode in xmlNode.ChildNodes)
                        {
                            switch (rootChildNode.Name)
                            {
                                case "contact":
                                    foreach (XmlNode contactChildNode in rootChildNode.ChildNodes)
                                    {
                                        switch (contactChildNode.Name)
                                        {
                                            case "adr3":
                                                xmlStuff.adr3 = contactChildNode.InnerText;
                                                break;
                                            case "city":
                                                xmlStuff.city = contactChildNode.InnerText;
                                                break;
                                            case "time_in_spain":
                                                foreach (XmlNode timeInSpainChildNode in contactChildNode.ChildNodes)
                                                {
                                                    switch (timeInSpainChildNode.Name)
                                                    {
                                                        case "departed_UK":
                                                            xmlStuff.departed_UK = timeInSpainChildNode.InnerText;
                                                            break;
                                                        case "residency":
                                                            xmlStuff.residency = timeInSpainChildNode.InnerText;
                                                            break;
                                                        default:
                                                            break;
                                                    }
                                                }
                                                break;
                                            case "oap":
                                                xmlStuff.oap = Convert.ToBoolean(contactChildNode.InnerText);
                                                break;
                                            case "case":
                                                foreach (XmlNode caseChildNode in contactChildNode.ChildNodes)
                                                {
                                                    switch (caseChildNode.Name)
                                                    {
                                                        case "docs_posted":
                                                            xmlStuff.docs_posted = caseChildNode.InnerText;
                                                            break;
                                                        case "completion":
                                                            xmlStuff.completion = caseChildNode.InnerText;
                                                            break;
                                                        case "payment_recieved_uk":
                                                            foreach (XmlNode paymentRecievedUkChildNode in caseChildNode.ChildNodes)
                                                            {
                                                                switch (paymentRecievedUkChildNode.Name)
                                                                {
                                                                    case "date_received":
                                                                        xmlStuff.date_received = paymentRecievedUkChildNode.InnerText;
                                                                        break;
                                                                    case "transfer_date":
                                                                        xmlStuff.transfer_date = paymentRecievedUkChildNode.InnerText;
                                                                        break;
                                                                    default:
                                                                        break;
                                                                }

                                                            }
                                                            break;
                                                        default:
                                                            break;

                                                    }
                                                }
                                                break;
                                            default:
                                                break;
                                        }

                                    }
                                    break;
                                default:
                                    break;
                            }
                        }
                        break;
                    default:
                        break;
                }
            }
            return xmlStuff;
        }

    }