System.Xml.Linq Namespace

Question

I have been given the task of calling a web service which returns an xml data feed which I am doing like so;

For Each r As DataRow in SomeDataTable
    Dim msFeed As String = string.format("http://some-feed.com?param={0}", r!SOME_VAL)
    Dim x As XDocument = XDocument.Load(msFeed)
Next

This is all fine but as you can see x just gets overwritten with every iteration. What I need is create an xDocument and add each feed from my loop but I am unsure how to proceed.

Thanks

Solution

Dim xAllFeeds As XElement = New XElement("Feeds")

For Each r As DataRow in SomeDataTable
    Dim msFeed As String = string.format("http://some-feed.com?param={0}", r!SOME_VAL)
    Dim x As XDocument = XDocument.Load(msFeed)
    xAllFeeds.Add(x.Root)
Next

Andrew Cooper · Accepted Answer · 2011-08-11 11:29:07Z

1

Not 100% sure of the VB syntax (C# is my language of choice), but this should be the gist of what you're after.

Dim xAllFeeds As XElement = New XElement("Feeds")
For Each r As DataRow in SomeDataTable
    Dim msFeed As String = string.format("http://some-feed.com?param={0}", r!SOME_VAL)
    Dim xDoc As XDocument = XDocument.Load(msFeed)
    xAllFeeds.Add(xDoc.Root)
Next

edited Aug 11, 2011 at 11:29

answered Aug 11, 2011 at 11:07

Andrew Cooper

32.7k5 gold badges86 silver badges124 bronze badges

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

2 Comments

Dooie Over a year ago

Thanks, rather than 'AppendChild' i just used 'Add'

Andrew Cooper Over a year ago

Sorry, It's not AppendChild, just Add (msdn.microsoft.com/en-us/library/system.xml.linq.xelement.aspx). I've adjusted the answer approriately.

Collectives™ on Stack Overflow

System.Xml.Linq Namespace

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related