Reading Xml

Question

Hi
I generated this xml file,

<?xml version="1.0" encoding="utf-8"?>  
<Root>  
 <Automobile>  
 <Country>Germany</Country>  
 <Manufacturers>Audi</Manufacturers>  
 <Manufacturers>BMW</Manufacturers>  
 <Manufacturers>Mercedes-Benz</Manufacturers>  
 </Automobile>  
 <Automobile>  
 <Country>United States</Country>  
 <Manufacturers>Jeep</Manufacturers>  
 <Manufacturers>Ford</Manufacturers>  
 <Manufacturers>Dodge</Manufacturers>  
 </Automobile>  
 <Automobile>  
 <Country>France</Country>  
 </Automobile>  
 <Automobile>  
 <Country></Country>  
 <Manufacturers></Manufacturers>  
 </Automobile>  
 <Automobile>  
 </Automobile>  
</Root>  

What is the easiest way to loop through XML using XmlDocument, so the output of the data be as :

Germany
Audi
BMW
Mercedes-Benz

United States
Jeep
Ford
Dodge

France

I can also add attributes to element to determine if item has children
Thanks in advance

Answer 1

@Yusuf , Welcome to Microsoft Q&A, you could try to use XmlDocument.SelectNodes to get your wanted data by looping through the xml file.

Here is a code example you could refer to.

 static void Main(string[] args)  
        {  
            XmlDocument doc = new XmlDocument();  
            doc.Load(@"test.xml");  
            foreach (XmlNode item in doc.SelectNodes("descendant::Automobile"))  
            {  
                foreach (XmlNode node in item.ChildNodes)  
                {  
                    if(node!=null)  
                    {  
                        Console.WriteLine(node.InnerText);  
                    }  
                }  
                Console.WriteLine("  ");  
              
            }  
        }  

Tested result:

Best Regards,
Jack

---

If the answer is the right solution, please click "Accept Answer" and upvote it.If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.