How to get child node info from xml file

Nils Olsson

8y1.2kLINQ

Hi,

I need some guidence to get some data out from an XML file using the query function in LINQ to XML

Here is my XML file structure

Ogilvie River

Canada

Yukon Territory

Ogilvie River

Alabama

12.000

65.664040

-138.122025

65.664124

-138.121826

192.000

65.669289

-138.111313

65.669205

-138.111496

There are thousand and thousands of ICAO nodes.

There are either a Runway node or none in a ICAO node.

There are from 2 to several Runway ids in a Runway node

I need to get a list of all Runway ids with its Hdg, Lat, Lon,FSStartLat and FSStartLon values for a specific ICAO id

I know how to open and query in general, but to get what I want I have so far not managed

How can this be done in the most effective way?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nanddeep Nachan8y ago
From Performance point of view prefer XDocument implementation over XmlDocument.
XmlDocument is a managed implemenation of the Document Object Model.
XDocument / XElement is a LINQ implementation.
0
Manav Pandya8y ago
Hello

For accessing sub-child node as well as child nodes of a parent you use like :

Your format [im using single value now] :
<Runway id="02">
  <Hdg>12.000Hdg>
  <Lat>65.664040Lat>
  <Lon>-138.122025Lon>
  <FSStartLat>65.664124FSStartLat>
  <FSStartLon>-138.121826FSStartLon>
Runway>
Now i have implemented same example with online xml file :
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text.RegularExpressions;
using System.Xml;

namespace Rextester
{
    public class Program
    {
        public static void Main(string[] args)
        {
            var demopath = "https://www.w3schools.com/xml/note.xml";
            string xmlStr;
            using(var wc = new System.Net.WebClient())
            {
                xmlStr = wc.DownloadString(demopath);
            }
            var xmlDoc = new XmlDocument();
            xmlDoc.LoadXml(xmlStr);
            XmlNodeList xnList = xmlDoc.SelectNodes("note");
            foreach (XmlNode xn in xnList)
            {
              string To = xn["to"].InnerText;
              string From = xn["from"].InnerText;
              string Heading = xn["heading"].InnerText;
              string Body = xn["body"].InnerText;
              Console.WriteLine(To);
              Console.WriteLine(From);
              Console.WriteLine(Heading);
              Console.WriteLine(Body);
            }
        }
    }
}
Format of online XML :
<note>
  <to>Toveto>
  <from>Janifrom>
  <heading>Reminderheading>
  <body>Don't forget me this weekend!body>
note>
you will get output like below :
Tove
Jani
Reminder
Don't forget me this weekend!

if you have child tree than follow nested if condition and use as per your requirement

Thanks
+2
Nils Olsson8y ago
1. XElement xEle = XElement.Load("XmlFileName.xml");
2. var list = xEle.Elements("data").ToList();
3. XElement el = (from p in list where p.Element("Runway id").Value == "02").FirstOrDefault();
This does not work at all. I believe you misread my question.
0

Altaf Ansari8y ago

Try like this :

XElement xEle = XElement.Load("XmlFileName.xml");
var list = xEle.Elements("data").ToList();
XElement el = (from p in list where p.Element("Runway id").Value == "02").FirstOrDefault();