[RESOLVED] xpath iteration

[davebat]

Hi I am using xpath to find nodes in xml and bind to a radiobuttonlist, so far I have

 Dim Doc As XPathDocument = New XPathDocument(localDrive & "\xml\jobs.xml")
                Dim Navigator As XPathNavigator
                Navigator = Doc.CreateNavigator()
                'Dim Iterator As XPathNodeIterator = Navigator.Select("/jobCodes/job[SoRCode[text()='" & Master.SORcode & "']]/DUIJobDescription")
                Dim Iterator As XPathNodeIterator = Navigator.Select("/jobCodes/job[SoRCode[text()='" & Master.SORcode & "']][RoomID[text()='" & Master.roomID & "']]/DUIJobDescription")
                While Iterator.MoveNext()
                    rblJobs.Items.Add(New ListItem(Iterator.Current.Value, Iterator.Current.Value))
                End While

The problem is this is binding the same value to both the text and value of the radiobutton list. How would I pull another node from the xml and display this as the value?

Thanks in advance

[davebat]

Figured out how top get other values;

/jobCodes/job[RoomID[text()='" & Master.roomID & "']][ComponentID[text()='" & Master.CompID & "']]/DUIJobDescription | /jobCodes/job[RoomID[text()='" & Master.roomID & "']][ComponentID[text()='" & Master.CompID & "']]/jobCode

But this doesnt do it in pairs so i end up with two radiobuttons, one with DUIJobDescription and one with jobCode.

Any ideas?

[davebat]

Well im stumped, so i cheated a bit

While Iterator.MoveNext()
                    If i Mod 2 = 0 Then
                        rblJobs.Items.Add(New ListItem(Iterator.Current.Value, Iterator.Current.Value))
                    Else
                        rblJobs.Items(i - 1).Value = Iterator.Current.Value
                    End If
                    i = i + 1
                End While

If anyone has a more elegant solution I'd love to hear it

[gep13]

Personally, when dealing with XPath, I always recommend this tool:

http://www.bubasoft.net/xpathbuilder/Xpathbuilder2.aspx

Can you upload a sample of the XML file you are using?

Gary

[davebat]

Here you are Gep, thanks. (I know the end nodes missing)

<jobCodes xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
	<job>
		<RoomID>1</RoomID>
		<RoomName>Bathroom / Toilet</RoomName>
		<ComponentID>2</ComponentID>
		<Componentname>Bath</Componentname>
		<DUIJobDescription>Renew white mastic seal around bath</DUIJobDescription>
		<SoRCode>whi_mas_bat_mt1</SoRCode>
		<TradeType>Multi In</TradeType>
		<SkillLevelRequired>2</SkillLevelRequired>
		<SuitableTrades>MT int, MT ext</SuitableTrades>
		<notes>Jobs which a specialist or MT can do</notes>
	</job>
	<job>
		<RoomID>1</RoomID>
		<RoomName>Bathroom / Toilet</RoomName>
		<ComponentID>2</ComponentID>
		<Componentname>Bath</Componentname>
		<DUIJobDescription>Repair damaged / chipped bath</DUIJobDescription>
		<SoRCode>dam_chi_bat_pl3</SoRCode>
		<TradeType>Plumbing</TradeType>
		<SkillLevelRequired>3</SkillLevelRequired>
		<SuitableTrades>Plumber</SuitableTrades>
		<notes>Jobs which only a specialist can do</notes>
	</job>
	<job>
		<RoomID>1</RoomID>
		<RoomName>Bathroom / Toilet</RoomName>
		<ComponentID>2</ComponentID>
		<Componentname>Bath</Componentname>
		<DUIJobDescription>Repair damaged bath panel</DUIJobDescription>
		<SoRCode>dam_bat_pan_mt3</SoRCode>
		<TradeType>Multi In</TradeType>
		<SkillLevelRequired>3</SkillLevelRequired>
		<SuitableTrades>MT int</SuitableTrades>
		<notes>Jobs which only a specialist can do</notes>
	</job>

Its the most basic xml i could make, but please don't spend too much time on this on my behalf, I've got loads more weird and wonderful wsHttpBinding problems to keep me occupied today!

[gep13]

So, just to confirm, can you give a quick few words about what you are trying to get out of the XML, and what you want to do with it?

Gary

[davebat]

I want to find a particular node for job based on roomId and componentID and then pull out SorCOde and description to bind to a radiobuttonlist as text and value respectively

[gep13]

Hey,

As with most things XML related, there are multiple ways to skin a cat.

Here is another way of getting the information that you need:

        Dim xpathDoc As XPathDocument = New XPathDocument(Server.MapPath("XmlFile1.xml"))
        Dim navigator As XPathNavigator = xpathDoc.CreateNavigator()
        Dim expression As XPathExpression = navigator.Compile("/jobCodes/job[RoomID['1']][ComponentID['2']]")
        Dim nodeIterator As XPathNodeIterator = navigator.Select(expression)

        While nodeIterator.MoveNext()
            Dim clone As XPathNavigator = nodeIterator.Current.Clone()
            clone.MoveToChild("DUIJobDescription", String.Empty)
            Dim duiDescription As String = clone.Value
            clone.MoveToParent()

            clone.MoveToChild("SoRCode", String.Empty)

            Dim sorCode As String = clone.Value

            Response.Write(String.Format("DUIDescription: {0}, SorCode: {1}", duiDescription, sorCode))
        End While

Here, I am only get a reference to the parent node, in this case "job" then navigating the navigator to get the information that is one level down from it.

Gary