XmlNode SelectSingleNode filter criteria not working

[sijcooke]

Hi all,

Many thanks in advance for any help given, it is much appreciated.

Please see attached code and XML file in the attached image.

Please can someone advise on this?

EDIT... im not sure if the text is visible enough in the attachment... if not, see below:

Dim BendProcesses As XmlNode = doc.SelectSingleNode("/BendPart/BendProcesses/BendProcess['BendId=4']/AxisPositions/LinearAxisPosition['AxisName=ZB1']")
MsgBox(BendProcesses.Attributes("RawValue").Value)

<?xml version="1.0" encoding="UTF-8" ?>
<BendPart box:version="1.0" Name="3 MS 100+50+200+50+50 tophat 135deg x 1000 long" Properties="M|fc3fdae9-1b5b-4812-8d4b-cd4866fe26fd|By%20Steel|3|a1dd1a04-c5c4-4e2d-965b-fb5cfcd9bfba|Xpert-150x3100-EH100-RFA-T12-HA6-AK" Thickness="3" xmlns:box="http://www.bystronic.com/bysoft7/scheme">
  <BendProcesses> 
    <BendProcess SheetHandling="Flip" BendId="3" BendAngle="135.0" BendDeduction="4782" ProcessOrder="1" ProcessGroup="3">
      <AxisPositions>
        <LinearAxisPosition AxisName="AK1" RawValue="323" />
        <LinearAxisPosition AxisName="AK2" RawValue="233" />
        <LinearAxisPosition AxisName="ZB1" RawValue="2334" />
        <LinearAxisPosition AxisName="ZB2" RawValue="252" />
      </AxisPositions>
    </BendProcess>
    <BendProcess SheetHandling="Flip" BendId="4" BendAngle="135.0" BendDeduction="1.86999035782" ProcessOrder="1" ProcessGroup="3">
      <AxisPositions>
        <LinearAxisPosition AxisName="AK1" RawValue="1753" />
        <LinearAxisPosition AxisName="AK2" RawValue="1754" />
        <LinearAxisPosition AxisName="ZB1" RawValue="1107.49969055" />
        <LinearAxisPosition AxisName="ZB2" RawValue="1992.50030945" />
      </AxisPositions>
    </BendProcess>
  </BendProcesses> 
</BendPart>

Thank you.

[.paul.]

I found some examples here...

https://learn.microsoft.com/en-us/do...e?view=net-7.0

[.paul.]

This worked for me...

Dim doc As New Xml.XmlDocument
doc.Load("C:\pathTo\test.xml")

'Create an XmlNamespaceManager for resolving namespaces.
Dim nsmgr As Xml.XmlNamespaceManager = New Xml.XmlNamespaceManager(doc.NameTable)
nsmgr.AddNamespace("bp", "box=http://www.bystronic.com/bysoft7/scheme")

Dim root As Xml.XmlElement = doc.DocumentElement

Dim BP As Xml.XmlNode = root.SelectSingleNode("//BendProcess[@BendId='4']/AxisPositions/LinearAxisPosition[@AxisName='ZB1']")

MsgBox(BP.Attributes("RawValue").Value)

[sijcooke]

Thanks for the replies... .paul. thats sorted it.. thank you. Im not sure how you mark it as solved. Thank you.

[.paul.]

At the top of this thread, above your original question, to the right, there’s a Thread Tools menu with an option to mark as RESOLVED

[dbasnett]

Using XElement and LINQ

The data

        Dim doc As XElement
        ' doc = XElement.Load("path here")

        ' for testing use literal

        doc = <BendPart box:version="1.0" Name="3 MS 100+50+200+50+50 tophat 135deg x 1000 long" Properties="M|fc3fdae9-1b5b-4812-8d4b-cd4866fe26fd|By%20Steel|3|a1dd1a04-c5c4-4e2d-965b-fb5cfcd9bfba|Xpert-150x3100-EH100-RFA-T12-HA6-AK" Thickness="3" xmlns:box="http://www.bystronic.com/bysoft7/scheme">
                  <BendProcesses>
                      <BendProcess SheetHandling="Flip" BendId="3" BendAngle="135.0" BendDeduction="4782" ProcessOrder="1" ProcessGroup="3">
                          <AxisPositions>
                              <LinearAxisPosition AxisName="AK1" RawValue="323"/>
                              <LinearAxisPosition AxisName="AK2" RawValue="233"/>
                              <LinearAxisPosition AxisName="ZB1" RawValue="2334"/>
                              <LinearAxisPosition AxisName="ZB2" RawValue="252"/>
                          </AxisPositions>
                      </BendProcess>
                      <BendProcess SheetHandling="Flip" BendId="4" BendAngle="135.0" BendDeduction="1.86999035782" ProcessOrder="1" ProcessGroup="3">
                          <AxisPositions>
                              <LinearAxisPosition AxisName="AK1" RawValue="1753"/>
                              <LinearAxisPosition AxisName="AK2" RawValue="1754"/>
                              <LinearAxisPosition AxisName="ZB1" RawValue="1107.49969055"/>
                              <LinearAxisPosition AxisName="ZB2" RawValue="1992.50030945"/>
                          </AxisPositions>
                      </BendProcess>
                  </BendProcesses>
              </BendPart>

The code

        Dim BendProcesses As XElement
        BendProcesses = (From el In doc...<BendProcess>
                            Where el.@BendId = "4"
                                From bp In el...<LinearAxisPosition>
                                    Where bp.@AxisName = "ZB2"
                                    Select bp Take 1).FirstOrDefault

        ' BendProcesses = <LinearAxisPosition AxisName="ZB2" RawValue="1992.50030945" />

[.paul.]

Using XElement and LINQ

The data

        Dim doc As XElement
        ' doc = XElement.Load("path here")

        ' for testing use literal

        doc = <BendPart box:version="1.0" Name="3 MS 100+50+200+50+50 tophat 135deg x 1000 long" Properties="M|fc3fdae9-1b5b-4812-8d4b-cd4866fe26fd|By%20Steel|3|a1dd1a04-c5c4-4e2d-965b-fb5cfcd9bfba|Xpert-150x3100-EH100-RFA-T12-HA6-AK" Thickness="3" xmlns:box="http://www.bystronic.com/bysoft7/scheme">
                  <BendProcesses>
                      <BendProcess SheetHandling="Flip" BendId="3" BendAngle="135.0" BendDeduction="4782" ProcessOrder="1" ProcessGroup="3">
                          <AxisPositions>
                              <LinearAxisPosition AxisName="AK1" RawValue="323"/>
                              <LinearAxisPosition AxisName="AK2" RawValue="233"/>
                              <LinearAxisPosition AxisName="ZB1" RawValue="2334"/>
                              <LinearAxisPosition AxisName="ZB2" RawValue="252"/>
                          </AxisPositions>
                      </BendProcess>
                      <BendProcess SheetHandling="Flip" BendId="4" BendAngle="135.0" BendDeduction="1.86999035782" ProcessOrder="1" ProcessGroup="3">
                          <AxisPositions>
                              <LinearAxisPosition AxisName="AK1" RawValue="1753"/>
                              <LinearAxisPosition AxisName="AK2" RawValue="1754"/>
                              <LinearAxisPosition AxisName="ZB1" RawValue="1107.49969055"/>
                              <LinearAxisPosition AxisName="ZB2" RawValue="1992.50030945"/>
                          </AxisPositions>
                      </BendProcess>
                  </BendProcesses>
              </BendPart>

The code

        Dim BendProcesses As XElement
        BendProcesses = (From el In doc...<BendProcess>
                            Where el.@BendId = "4"
                                From bp In el...<LinearAxisPosition>
                                    Where bp.@AxisName = "ZB2"
                                    Select bp Take 1).FirstOrDefault

        ' BendProcesses = <LinearAxisPosition AxisName="ZB2" RawValue="1992.50030945" />

In this case, I don’t see any great advantage of using LINQ over XPath…

[dbasnett]

In this case, I don’t see any great advantage of using LINQ over XPath…

For me personally I like the clarity of the query, but I'm sure the XPath statement is as clear to you.