Avatar of dobbinjp
dobbinjp
 asked on

read value from xmlnode returned by asp.net web service

I have developed a web service that accepts an input code and returns data as an XMLnode. The format of the returned XMLnode is attached. I can read the entire returned xmlnode and bind it to a gridview with my attached code. However, I need to be able to read the individual values and my code doesn't seem to work where I am trying to display one particular value as a label (I get null reference exceptions). The web service is located at the following location:

http://transp2.vuse.vanderbilt.edu/webservices/service.asmx

The service is "getprevandnext" and to use it pass a value of "19I0065001" to see what is returned.

If there is a better way to read this data than my current code, please advise.

Thanks for your help!!
'returned data format below
 
<Data>
<PreviousID>94I0065001</PreviousID>
<NextID>83I0065001</NextID>
<LogMile>22.17</LogMile>
</Data>
 
'here is my code, everything works except where noted (Label 4 text)
 
        Dim consumewebservice As New edu.vanderbilt.vuse.transp2.Service
 
        Dim reader As XmlNodeReader
        Dim ds As New DataSet()
        Dim wsNode As XmlNode
 
        wsNode = consumewebservice.GetPrevandNext("19I0065001")
        'the following line does not work
        Label4.Text = wsNode.Attributes("PreviousID").Value.ToString
        
        reader = New XmlNodeReader(wsNode)
 
        ds.ReadXml(reader)
 
        GridView1.DataSource = ds.Tables("Data")
        GridView1.DataBind()
        GridView1.AutoGenerateColumns = True

Open in new window

ASP.NETXML

Avatar of undefined
Last Comment
dobbinjp

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Dabas

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
dobbinjp

ASKER
thanks for the quick solution, it worked perfectly!!!!
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23