Link to home
Start Free TrialLog in
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

ASKER CERTIFIED SOLUTION
Avatar of Dabas
Dabas
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dobbinjp
dobbinjp

ASKER

thanks for the quick solution, it worked perfectly!!!!