Status: Solved
Priority: Medium
Security: Public
Views: 318
Last Modified: 2013-01-17

Problems reading xml node

I have a particular node that I'm trying to get to in the attached file.

I'm trying to use this code:

refPlanNodeList = xmlDemo.SelectNodes("PPMDResults/Results/patientlist/patient/refplanlist")
For Each refPlanNode In refPlanNodeList
refProv = refPlanNode.SelectSingleNode("refplan").Attributes("refprov").Value
If refProv.Replace("rprov", "") = physid Then
result = refPlanNode.SelectSingleNode("refplan/id").InnerText
End If
Next

I'm trying to loop through each refplan node but the above doesn't seem to work.
Demo.xml

rutledgj

Asked: 2013-01-17

Advertise Here

1 Solution

LVL 35

YZlatCommented: 2013-01-17

try this instead:

refPlanNodeList = xmlDemo.SelectNodes("PPMDResults/Results/patientlist/patient/refplanlist/refplan")
        For Each refPlanNode In refPlanNodeList
            refProv = refPlanNode.Attributes("refprov").Value
            If refProv.Replace("rprov", "") = physid Then
                result = refPlanNode.SelectSingleNode("refplan/id").InnerText
            End If
        Next

Open in new window

LVL 35

YZlatCommented: 2013-01-17

instead of looping through refplan nodes you tried looping through refplanlist, and there is only one in your xml

LVL 35

YZlatCommented: 2013-01-17

disregard post above - i found one more isssue - the way you retrieve id attribute. Use

refPlanNodeList = xmlDemo.SelectNodes("PPMDResults/Results/patientlist/patient/refplanlist/refplan")
        For Each refPlanNode In refPlanNodeList
            refProv = refPlanNode.Attributes("refprov").Value
            If refProv.Replace("rprov", "") = physid Then ''physid Then
                result = refPlanNode.Attributes("id").Value
            End If
        Next

Open in new window

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Expand your skills with this month's free Premium course.

Problems reading xml node

Join & Write a Comment Already a member? Login.

Featured Post