Parse XML in vb.net (Multiple Nodes?)

Question

Dim page As XElement = _
<response>
    <results>
        <result>
            <status>OK</status>
            <number>phonenumberhere</number>
            <wless>y</wless>
            <carrier_name>ATT Mobility</carrier_name>
            <sms_address>[email protected]</sms_address>
            <mms_address>[email protected]</mms_address>
        </result>
    </results>
</response>

Me.addr = page.Element("sms_address").Value

It crashes on Me.addr = page.Element("sms_address").Value I need to store the sms_address as a string.

Can anyone help?

John Saunders · Accepted Answer · 2014-05-14 00:50:42Z

1

Try

Dim page As XElement = <response><results><result><status>OK</status><number>phonenumberhere</number><wless>y</wless><carrier_name>ATT Mobility</carrier_name><sms_address>[email protected]</sms_address><mms_address>[email protected]</mms_address></result></results></response>
Me.addr = page.Element("results") _
              .Element("result") _
              .Element("sms_address").Value

The element you were looking for is not at the top, so page.Element("sms_address") won't find it.

Alternatively, since you're lucky enough to be using VB.NET, you can use

page...<sms_address>.Value

or

page.<results>.<result>.<sms_address>.Value

edited May 14, 2014 at 0:50

answered May 14, 2014 at 0:07

John Saunders

162k26 gold badges252 silver badges403 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Ryan Shtirmer Over a year ago

I get an error Leading '.' or '!' can only appear inside a 'With' statement.

Enigmativity Over a year ago

Add line continuation characters to the end of each broken line. Also the first .Element("response") is wrong. Remove that.

John Saunders Over a year ago

@Enigmativity: fixed, I think. My Visual Studio is broken right now, so I can't test it. And I thought they had gotten rid of the need for line continuations. Would it have worked if I broke the line after the .?

Enigmativity Over a year ago

@JohnSaunders - They got rid of most of the cases where you needed a line continuation. Now it's real annoying, not just annoying. And yes, if you did the . at the end of the line you wouldn't need the line continuations, but that just makes it hard to read.

Collectives™ on Stack Overflow

Parse XML in vb.net (Multiple Nodes?)

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related