Finding an element based on other element in XML

If you need to query attributes, i.e. ssn, this will do the job:

node = doc.SelectSingleNode("COLLECTION/CD/ARTIST[@ssn='a12']");

However, thinking to your next question, you might like to put the ssn on the CD element, such that when you query for a12, you get back ARTIST, YEAR, TITLE...

HTH

suppose if i add an attribute to the foll. xml file:

       xml version=”1.0” encoding=”UTF-8” standalone=”yes”?>

      

          

             Queen1

             

             1975

          

          

             Queen2

         

         1975

      

  
I m doing the foll. now:

    XmlDocument doc = new XmlDocument();
    doc.Load(XMLPath);
    XmlElement elem = doc.GetElementById("a11");
    MessageBox.Show(elem.OuterXml);

wat i get is the complete thing:              Queen
Is it possible to get either ONLY 'a11' or 'Queen.'
Thank you.

This should help; given a WinForm, two textbox controls and a reference to System.Xml:

XmlDocument doc = new XmlDocument();

doc.LoadXml("Queen1975Queen1975");

textBox1.Text = doc.InnerXml;

XmlNode node = doc.SelectSingleNode("COLLECTION/CD[ARTIST='Queen']/TITLE");

textBox2.Text = node.InnerXml;

GetElementsByTagName is useful if you want a list of elements back, however it doesn't help if your want 'specific' elements back...as in your case.

HTH