Looping through XML element c#

Question

How to access EntityAttributeValue -> Value and EntityAttributeValue -> Attribute - > Name using c#

 
    
      
      
        1
        Internet Filter 1
        other
      
      0
      
    
    
      
      
        0
        Product Type
        category
      
      0
      
    
    
      Beauty
      
        1
        Department
        global
      
      7
      
    
    
      Women
      
        2
        Gender
        global
      
      1
      
    
    
      CHANEL
      
        8
        Brand
        global
      
      2958

Accepted Answer

@Shabbir Daruwala , Welcome to Microsoft Q&A,

You can save your xml text to a xml file. Based on my test, the xml you provided is need to modify, the following xml is an example.

  
  
       
         
         
         1  
         Internet Filter 1  
         other  
         
       0  
         
       
       
         
         
         0  
         Product Type  
         category  
         
       0  
         
       
       
       Beauty  
         
         1  
         Department  
         global  
         
       7  
         
       
       
       Women  
         
         2  
         Gender  
         global  
         
       1  
         
       
       
       CHANEL  
         
         8  
         Brand  
         global  
         
       2958

Then, you could refer to the following code to use linq to xml to get the value you wanted.

private void button1_Click(object sender, EventArgs e)  
        {  
            XDocument doc = XDocument.Load("D:\test.xml");  
            var values = doc.Descendants("EntityAttributeValue").Select(i=>i.Element("Attribute").Element("Name").Value);  
            foreach (var item in values)  
            {  
                listBox1.Items.Add(item.ToString());  
            }  
             
        }

Result:

If the answer is the right solution, please click "Accept Answer" and kindly 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.

Answer

You can just load your XML into an XmlDocument and then traverse the tree for the elements you want:

using System.Xml;

var xml = @"
   
     
       
       
         1
         Internet Filter 1
         other
       
       0
       
     
     
       
       
         0
         Product Type
         category
       
       0
       
     
     
       Beauty
       
         1
         Department
         global
       
       7
       
     
     
       Women
       
         2
         Gender
         global
       
       1
       
     
     
       CHANEL
       
         8
         Brand
         global
       
       2958
       
     
   
";

StringReader reader = new StringReader(xml);
XmlDocument document = new XmlDocument();

document.Load(reader);

XmlNodeList entities = document.SelectNodes("/AttributeValues/EntityAttributeValue");

foreach (XmlNode entity in entities) {
    string name = entity["Attribute"]["Name"].InnerText;
    string value = entity["Value"].InnerText;

    Console.WriteLine($"Name: {name}, Value: {value}");
}

By the way I had to add an xmlns to the AttributeValues root element. If your snippet is nested inside a larger document you may need need that, it's just so xsi:nil is defined for your ProductTypeId to use.

Looping through XML element c#

1 additional answer