title: load xml into dataset with column filtering
body: <p>i would like to load xml into dataset with only 2 columns (name, price)</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="utf-8" ?&gt;
  &lt;file&gt;
  &lt;record&gt;
      &lt;name&gt;A&lt;/name&gt;
      &lt;address&gt;B&lt;/address&gt;
      &lt;date&gt;12-12-2010&lt;/date&gt;
      &lt;price&gt;100&lt;/price&gt;
  &lt;/record&gt;
  &lt;record&gt;
      &lt;name&gt;B&lt;/name&gt;
      &lt;address&gt;C&lt;/address&gt;
      &lt;date&gt;01-01-1999&lt;/date&gt;
      &lt;price&gt;23&lt;/price&gt;
  &lt;/record&gt;
  &lt;/file&gt;
  </code></pre>
  
  <p>here is my c# code:</p>
  
  <pre><code>string myXMLfile = "C:\\asdf.xml";
  DataSet ds = new DataSet();
  
  ds.ReadXml(myXMLfile);
  
  dataGrid1.DataSource = ds;
  dataGrid1.DataMember = "record";
  </code></pre>
  
  <p>that displays all of the records. what can i do to filter the data? </p>
  
  <p>filter dataset/dataview/datatable </p>
  
  <p>or read specific xml elements and load them into dataset ?</p>
  
  <p>or filtering datagrdview?</p>
  
  <p>many thanks</p>