tags:

views:

69

answers:

3

Given this URL:

http://www.dreamincode.net/forums/xml.php?showuser=1253

How can I download the resulting XML file and have it loaded to memory so I can grab information from it using Linq?

Thanks for the help.

+4  A: 

Load string:

string xml = new WebClient().DownloadString(url);

Then load into XML:

XDocument doc = XDocument.Parse(xml);

For example:

[Test]
public void TestSample()
{
    string url = "http://www.dreamincode.net/forums/xml.php?showuser=1253";
    string xml;
    using (var webClient = new WebClient())
    {
        xml = webClient.DownloadString(url);
    }

    XDocument doc = XDocument.Parse(xml);

    // in the result profile with id name is 'Nate'
    string name = doc.XPathSelectElement("/ipb/profile[id='1253']/name").Value;
    Assert.That(name, Is.EqualTo("Nate"));
}
Elisha
I'm getting an error that doc doesn't have a XPathSelectElement method. What might I be doing wrong?
Sergio Tapia
@Sergio Tapia, It's an XML LINQ extension method: http://msdn.microsoft.com/en-us/library/bb156083.aspxIt needs to add `using System.Xml.Linq` to imports.
Elisha
+1  A: 

You can use the WebClient class:

WebClient client = new WebClient ();
Stream data = client.OpenRead ("http://example.com");
StreamReader reader = new StreamReader (data);
string s = reader.ReadToEnd ();
Console.WriteLine (s);
data.Close ();
reader.Close ();

Though using DownloadString is easier:

WebClient client = new WebClient ();
string s = client.DownloadString("http://example.com");

You can load the resulting string into an XmlDocument.

Oded
+7  A: 

Why complicate things? This works:

var xml = XDocument.Load("http://www.dreamincode.net/forums/xml.php?showuser=1253");
Gabe