title: Filter a DataSet by the current date
body: <p>I have a column 'date' in my DataSet. I would like to filter this column by the current date.
  I want to display all the orders just for today (current date).</p>
  
  <p>I tried this but it's not working:</p>
  
  <pre><code>DataSet ds = new DataSet();
  ds.ReadXml("C:\\sites.xml");
  
  dataGridView1.DataSource = ds.Tables[0];
  
  this.dataGridView1.Columns[1].Visible = false;
  
  //filter
  ds.Tables[0].DefaultView.RowFilter = "date = '" + DateTime.Now.ToString() + "'";
  </code></pre>
  
  <p>XML file :</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8" standalone="yes"?&gt;
  &lt;sites xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"&gt;
      &lt;site technical="1"&gt;
          &lt;name&gt;brian&lt;/name&gt;
          &lt;url&gt;www.microsoft.com&lt;/url&gt;
          &lt;date&gt;01/02/2012&lt;/date&gt;
      &lt;/site&gt;
      &lt;site technical="2"&gt;
          &lt;name&gt;Mike&lt;/name&gt;
          &lt;url&gt;www.news.com&lt;/url&gt;
          &lt;date&gt;01/02/2012&lt;/date&gt;
      &lt;/site&gt;
      &lt;site technical="3"&gt;
          &lt;name&gt;leslie&lt;/name&gt;
          &lt;url&gt;www.cnet.com&lt;/url&gt;
          &lt;date&gt;02/01/2012&lt;/date&gt;
      &lt;/site&gt;
      &lt;site technical="4"&gt;
          &lt;name&gt;rebeca&lt;/name&gt;
          &lt;url&gt;www.gamespot.com&lt;/url&gt;
          &lt;date&gt;01/01/2012&lt;/date&gt;
      &lt;/site&gt;
      &lt;site technical="5"&gt;
          &lt;name&gt;jenifer&lt;/name&gt;
          &lt;url&gt;www.google.com&lt;/url&gt;
          &lt;date&gt;02/01/2012&lt;/date&gt;
      &lt;/site&gt;
  &lt;/sites&gt;
  </code></pre>