XML and XmlDataSource Control

Re: select single node question

Martin_Honnen — Wed, 01 Jul 2009 18:04:22 GMT

Let's assume the XML you have is

<response>
  <lst name="responseHeader">
    <int name="status">0</int>
    <lst name="params">
      <str name="rows">50</str>
    </lst>
  </lst>
</response>

then this snippet of C#

            XmlDocument xmlDocumentInstance = new XmlDocument();
            xmlDocumentInstance.Load(@"..\..\XMLFile1.xml");
            XmlElement el = xmlDocumentInstance.SelectSingleNode("//str[@name = 'rows']") as XmlElement;
            if (el != null)
            {
                Console.WriteLine(el.InnerText);
            }

outputs 50.

Re: select single node question

tpiazza55 — Wed, 01 Jul 2009 17:47:16 GMT

<response>
	<lst name="responseHeader">		   
                          <int name="status">0</int>	  
                          <lst name="params">
		<str name="rows">50</str>
	           </lst>
	</lst>
</response>


i need the vlaue of rows

Re: select single node question

Martin_Honnen — Wed, 01 Jul 2009 17:36:19 GMT

Please post the real XML you have and we can find out why the XPath does not find anything. Namespaces might be one reason.

What you have posted now is not XML at all as you have start tags <lst> which need to be closed as </lst> but you have not done that.

Re: select single node question

tpiazza55 — Wed, 01 Jul 2009 17:19:58 GMT

<lst>

what i need to do is get to the name="1" so i can getthe value 14

XmlElement el = xmlDocumentInstance.SelectSingleNode("//int[@name = 1]") as XmlElement;

doesnt seem to find it

the only way i have been able to get to it is using foreach node and drilling down that way

Re: select single node question

Martin_Honnen — Wed, 01 Jul 2009 16:52:59 GMT

What does SelectSingleNode have to do with Attributes.GetNamedItem? I don't understand your question.

If you want to find the first element where the name attribute has the value 1 then use

XmlElement el = xmlDocumentInstance.SelectSingleNode("//*[@name = 1]") as XmlElement;

If you want to find the first int element where the name attribute has the value 1 then use

XmlElement el = xmlDocumentInstance.SelectSingleNode("//int[@name = 1]") as XmlElement;

If that does not help then you need to elaborate why you think you need Attributes.GetNamedItem with SelectSingleNode or what exactly you want to achieve.

select single node question

tpiazza55 — Wed, 01 Jul 2009 16:37:01 GMT

how do i do a selectsinglenode to get to the name = 1 node when i have to use Attributes.GetNamedItem("name")

<lst name="counts">
    <lst name="fields">
         <lst name="ID">
              <int name="1">14</int>
         <lst>
    <lst>
<lst>