How to get child node info from xml file

Question

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?

Manav Pandya · Answer

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.000 Hdg > Lat > 65.664040 Lat > Lon > -138.122025 Lon > FSStartLat > 65.664124 FSStartLat > FSStartLon > -138.121826 FSStartLon > 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 > Tove to > from > Jani from > heading > Reminder heading > 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

Nanddeep Nachan · Answer

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.

Nils Olsson · Answer

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(); This does not work at all. I believe you misread my question.

Altaf Ansari · Answer

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();