General

Re: Problem getting data with Iterator and Navigator

PaulRAnderson — Tue, 24 Jul 2012 18:28:49 GMT

Thank you! Your answer set me on the right path.

I changed device to devices.Current as you suggested and also removed the definition of the innermost XPathNavigator, as the value of issue is the InnerXml. The code that works is:

    XPathNodeIterator devices = MainDataSource.CreateNavigator().Select("/root/device", NamespaceManager);
     while (devices.MoveNext())
     {
         XPathNavigator device = devices.Current.CreateNavigator().SelectSingleNode("name", NamespaceManager);
         if (device != null)
         {
             String deviceName = device.Value;
             XPathNodeIterator issues = devices.Current.CreateNavigator().Select("/summary/issue", NamespaceManager);
             while (issues.MoveNext())
             {
                String issue = issues.Current.InnerXml;
            }
         }
     }

Re: Problem getting data with Iterator and Navigator

Jimmy — Tue, 24 Jul 2012 16:32:36 GMT

In this line:

XPathNodeIterator issues = device.CreateNavigator().Select("summary/issue", NamespaceManager);

how about using devices.Current instead of device? I think that's the problem.

Problem getting data with Iterator and Navigator

PaulRAnderson — Tue, 24 Jul 2012 15:37:58 GMT

I am trying to get the values of two elements in an XML file and am almost there but it's not quite working.

A simplistic view of the XML is:

--------------------------------------------------------------------------------
    <root>
       <device> (repeating)
           <name>
           <summary>
               <issue> (repeating)
--------------------------------------------------------------------------------

I want to get all names and all issues for each name. The string deviceName correctly contains name but I can't get issue because device contains the children, not the children of the children.

--------------------------------------------------------------------------------

    XPathNodeIterator devices = MainDataSource.CreateNavigator().Select("/root/device", NamespaceManager);
    while (devices.MoveNext())
    {
        XPathNavigator device = devices.Current.CreateNavigator().SelectSingleNode("name", NamespaceManager);
        if (device != null)
        {
            String deviceName = device.Value;
            XPathNodeIterator issues = device.CreateNavigator().Select("summary/issue", NamespaceManager);
            while (issues.MoveNext())
            {
                XPathNavigator issue = issues.Current.CreateNavigator().SelectSingleNode(issuePath, NamespaceManager);
                if (issue != null)
                {
                    String issueValue = issue.Value;
                }
            }
        }
    }

--------------------------------------------------------------------------------

The code in the "while(issues.MoveNext())" section never executes because there are no issues.

What can I do to either grab all data underneath <device> or should I step through manually somehow and grab issues?

Paul