title: How to load XML into a DataTable?
body: <p>I want to load an XML file on the internet into a <code>DataTable</code> in C#. The XML is loaded from <a href="http://rates.fxcm.com/RatesXML" rel="nofollow">http://rates.fxcm.com/RatesXML</a> and looks like this:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;Rates&gt;
      &lt;Rate Symbol="EURUSD"&gt;
          &lt;Bid&gt;1.29174&lt;/Bid&gt;
          &lt;Ask&gt;1.29198&lt;/Ask&gt;
          &lt;High&gt;1.29407&lt;/High&gt;
          &lt;Low&gt;1.28723&lt;/Low&gt;
          &lt;Direction&gt;-1&lt;/Direction&gt;
          &lt;Last&gt;14:56:48&lt;/Last&gt;
      &lt;/Rate&gt;
      &lt;Rate Symbol="USDJPY"&gt;
          &lt;Bid&gt;82.862&lt;/Bid&gt;
          &lt;Ask&gt;82.885&lt;/Ask&gt;
          &lt;High&gt;83.293&lt;/High&gt;
          &lt;Low&gt;82.847&lt;/Low&gt;
          &lt;Direction&gt;1&lt;/Direction&gt;
          &lt;Last&gt;14:56:47&lt;/Last&gt;
      &lt;/Rate&gt;
      &lt;!-- More like the above --&gt;
  &lt;/Rates&gt;
  </code></pre>
  
  <p>Can I use the <a href="http://msdn.microsoft.com/en-us/library/system.data.datatable.readxml.aspx" rel="nofollow"><code>ReadXml</code> method of the <code>DataTable</code> class</a> to read the XML, or do I need some kind of http request to get it first into a string?</p>
  
  <p>EDIT:
  I've just written the following </p>
  
  <pre><code>public DataTable GetCurrentFxPrices(string URL)
  {
      DataSet ds = new DataSet("fxPrices");
      ds.ReadXml(URL);
  
  }
  </code></pre>
  
  <p>and it is trying to read the data, but I am behind a corporate firewall. I'm really clueless now how to get around this. I get this error:</p>
  
  <p><code>System.Net.WebException: The remote server returned an error: (407) Proxy Authentication Required.</code></p>
  
  <p>In firefox I have an HTTP proxy set with a port number. Can I set that somewhere in my app?</p>