How to read all xml nodes for respective Attribute values using c#

Question

I would like to execute different set of xml nodes which are being identified by their respective attributes values in xml. But what i am facing is that only the set 1 xml nodes are getting executed even the second attribute value is being identified.Here is my current code:

for (int m = 0; m < 10; m++)
{
    attrVal_New = Update_Bugs[m].Attributes["TestCondition"].Value;
    foreach (string attr in attrVal_New.Split(','))
    {
        Console.WriteLine(attr);
        ....

Please find the sample xml as follows:

<DrWatson>
  <Bugs Name="Testing 11" TestCondition="STATE">
    <Bug>
      <family>ESG</family>
      <product>Dr.Watson</product>
      <duplicateId>Blank</duplicateId>
      <note></note>
    </Bug>
    <Bug>
          <family>ESG</family>
          <product>Dr.Watson</product>
          <duplicateId>Blank</duplicateId>
          <note></note>
    </Bug>
  </Bugs>
  <Bugs Name="Testing 22" TestCondition="STATUS">
    <Bug>
          <family>ESG</family>
          <product>Dr.Watson</product>
          <duplicateId>Blank</duplicateId>
          <note></note>
    </Bug>
    <Bug>
    <family>ESG</family>
          <product>Dr.Watson</product>
          <duplicateId>Blank</duplicateId>
          <note></note>
    </Bug>
  </Bugs>
</DrWatson>

Please note that there are different attribute value defined under TestCondition as 'STATE' and STATUS. when running this loop second time the attribute value is being detected as 'STATUS' but it executes the xml nodes which are present under 'STATE' attribute value.Please suggest.

Here is the code snippet for 'Update Bugs' as follows:

 XmlDocument XDoc = new DrWatsonCore().LoadXMLFromFile(FilePath_EXPRESS_API_BugAdd_CreateBugs_DataFile);
                XmlNodeList Update_Bugs = XDoc.GetElementsByTagName("Bugs");

i am using this part to identify the Attribute Tag Names in the xml available under 'TestCondition' in my xml.

This is what i am doing after your suggestion and i am facing the same issue again as i am picking up the second attribute value but the set of xml nodes available under STATE attribute value is getting executed.

for (int m = 0; m < 10; m++)
                {
                    XmlAttributeCollection coll = Update_Bugs.Item(m).Attributes;
                    string value = coll.Item(m).Value;
                attrVal_New = Update_Bugs[m].Attributes["TestCondition"].Value;

                //m++;
                foreach (string attr in attrVal_New.Split(','))
                {                        

                        string attributelowercase = attr.ToLower();                        
                        //Step1: Create Bugs
                        List<string> BugWSResponseList1 = new List<string>();                        
                        BugWSResponseList1 = CreateBugs(FilePath_EXPRESS_API_BugAdd_CreateBugs_DataFile, newValue);

It would be useful to show type and code used to obtain Update_Bugs object. — Alexei Levenkov
– Alexei Levenkov, Commented Sep 14, 2013 at 7:17
I've edited your sample and removed everything that either commented out or not using Update_Bugs - it looks like you did not post portion of the code that should be using Update_Bugs[m] node... — Alexei Levenkov
– Alexei Levenkov, Commented Sep 14, 2013 at 7:22
@ Alexei Levenkov Please find my updated code with the code snippet for 'Update_Bugs' — user2778482
– user2778482, Commented Sep 14, 2013 at 7:26
@Vikram Bose yes thats right.. Update_Bugs is the xml node identified on the basis of Attribute Value Tag Name under 'TestCondition' within xml. — user2778482
– user2778482, Commented Sep 14, 2013 at 7:33

Vikram Bose · Accepted Answer · 2013-09-14 10:15:10Z

1

    foreach (XmlElement xmlElement in nodeList)
            {
                foreach (XmlElement xmlElement1 in xmlElement.ChildNodes)
                {
                    foreach (XmlElement xmlElement2 in xmlElement1.ChildNodes)
                    {
                        string value = xmlElement2.InnerText;
                        Debug.WriteLine(value);
                    }
                }
            }

Output :

ESG
Dr.Vatson
Blank

ESG
Dr.Hello
Blank

ESG
Dr.Vikram
Blank

ESG
Dr.Watson
Blank

edited Sep 14, 2013 at 10:15

answered Sep 14, 2013 at 7:45

Vikram Bose

3,3852 gold badges20 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user2778482 Over a year ago

Please find my updated code snippet after using your workaround.

user2778482 Over a year ago

My Mis.. Please find the updated code i am using for trying your workaround

Marco · Accepted Answer · 2013-09-14 10:24:21Z

0

I do not knwo why tou have a for loop or why you have the split on the attribute value, but I would write the code like this

//Get all the bugs.
XmlNodeList Update_Bugs = XDoc.GetElementsByTagName("Bugs");

//Loop through the bugs
foreach(XmlNode updateBug in Update_Bugs)
{
    //Check for the test condition
    if (updateBug.Attributes["TestCondition"] != null)
    {
        //Get the value of TestCondition.
        string value = updateBug.Attributes["TestCondition"].Value;
        string attributelowercase = value.ToLower();
        Console.WriteLine(attributelowercase);
        //Get the children of the node. This will be the <Bug> nodes.
        XmlNodeList newValue = updateBug.ChildNodes;
        //Get the xml string of the bugs
        string xmlString = updateBug.InnerXml;
        Console.WriteLine(xmlString);
    }
}

This will give you as output the TestCondotion and the XML between the tags e.g.:

<Bug>
  <family>ESG</family>
  <product>Dr.Watson</product>
  <duplicateId>Blank</duplicateId>
  <note></note>
</Bug>
<Bug>
  <family>ESG</family>
  <product>Dr.Watson</product>
  <duplicateId>Blank</duplicateId>
  <note></note>
</Bug>

How to process this depends on wht you want do do with it.

edited Sep 14, 2013 at 10:24

answered Sep 14, 2013 at 10:06

Marco

4304 silver badges11 bronze badges

1 Comment

user2778482 Over a year ago

How can i get the newvalue response as xml document not as string.Please suggest.

Collectives™ on Stack Overflow

How to read all xml nodes for respective Attribute values using c#

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related