title: How to load ASP.Net Grid from a multi table Dataset
body: <p>I am new to ASP.Net and I want to read following XML in to ASP.Net Grid.
  When I load the xml into DataSet and use the following code, it only shows me first table from the XML.</p>
  <pre><code>DataSet DS = new DataSet();        
  DS.ReadXml(Server.MapPath(&quot;.\\data\\demo_portfolio.xml&quot;));        
  GridView1.DataSource = DS;    
  GridView1.DataBind();
  </code></pre>
  <p><strong>XML TO READ</strong></p>
  <pre><code>&lt;portfolio&gt;
    &lt;script&gt;
      &lt;name&gt;&quot;HDFC.BSE&quot;&lt;/name&gt;
      &lt;row&gt;
        &lt;PurchasePrice&gt;2433.75&lt;/PurchasePrice&gt;
        &lt;PurchaseDate&gt;2020-01-01&lt;/PurchaseDate&gt;
        &lt;PurchaseQty&gt;5&lt;/PurchaseQty&gt;
        &lt;CommissionPaid&gt;20&lt;/CommissionPaid&gt;
        &lt;CostofInvestment&gt;12188.75&lt;/CostofInvestment&gt;
      &lt;/row&gt;
      &lt;row&gt;
        &lt;PurchasePrice&gt;2455.30&lt;/PurchasePrice&gt;
        &lt;PurchaseDate&gt;2020-01-20&lt;/PurchaseDate&gt;
        &lt;PurchaseQty&gt;4&lt;/PurchaseQty&gt;
        &lt;CommissionPaid&gt;30&lt;/CommissionPaid&gt;
        &lt;CostofInvestment&gt;9851.20&lt;/CostofInvestment&gt;
      &lt;/row&gt;
      &lt;row&gt;
        &lt;PurchasePrice&gt;1874.90&lt;/PurchasePrice&gt;
        &lt;PurchaseDate&gt;2020-03-12&lt;/PurchaseDate&gt;
        &lt;PurchaseQty&gt;6&lt;/PurchaseQty&gt;
        &lt;CommissionPaid&gt;30&lt;/CommissionPaid&gt;
        &lt;CostofInvestment&gt;11279.40&lt;/CostofInvestment&gt;
      &lt;/row&gt;
    &lt;/script&gt;
  &lt;/portfolio&gt;
  </code></pre>