title: Data grid row filter return less than
body: <p>when i run this to filter my xml file it returns all rows even those higher than the given amount. </p>
  
  <pre><code>DataSet ds = new DataSet();
  
  
  
  ds.ReadXml("Database.xml");
  
  string filter = "";
  filter = "Dayvisited &lt;= '20'";
  
  DataView dv = new DataView(ds.Tables[0]);
  dv.RowFilter = filter;
  dataGridView2.DataSource = dv;
  dataGridView2.Columns[4].Visible = false;
  </code></pre>
  
  <p>this is my xml </p>
  
  <pre><code>&lt;root&gt;
    &lt;place&gt;
      &lt;Name /&gt;
      &lt;Location /&gt;
      &lt;Info /&gt;
      &lt;Dayvisited /&gt;
      &lt;userdata /&gt;
    &lt;/place&gt;
    &lt;place&gt;
      &lt;Name&gt;home&lt;/Name&gt;
      &lt;Location&gt;x-292 z 277&lt;/Location&gt;
      &lt;Info&gt;home&lt;/Info&gt;
      &lt;Dayvisited&gt;100&lt;/Dayvisited&gt;
      &lt;userdata&gt;u&lt;/userdata&gt;
    &lt;/place&gt;
    &lt;place&gt;
      &lt;Name&gt;base&lt;/Name&gt;
      &lt;Location&gt;x868 z986&lt;/Location&gt;
      &lt;Info&gt;stuff&lt;/Info&gt;
      &lt;Dayvisited&gt;20&lt;/Dayvisited&gt;
      &lt;userdata&gt;u&lt;/userdata&gt;
    &lt;/place&gt;
    &lt;place&gt;
      &lt;Name&gt;town&lt;/Name&gt;
      &lt;Location&gt;x 990 z-2485&lt;/Location&gt;
      &lt;Info&gt;gas station&lt;/Info&gt;
      &lt;Dayvisited&gt;12&lt;/Dayvisited&gt;
      &lt;userdata&gt;u&lt;/userdata&gt;
    &lt;/place&gt;
    &lt;place&gt;
      &lt;Name&gt;crossing&lt;/Name&gt;
      &lt;Location&gt;x 90 z-2998&lt;/Location&gt;
      &lt;Info&gt;working stiff&lt;/Info&gt;
      &lt;Dayvisited&gt;11&lt;/Dayvisited&gt;
      &lt;userdata&gt;u&lt;/userdata&gt;
    &lt;/place&gt;
    &lt;place&gt;
      &lt;Name&gt;home&lt;/Name&gt;
      &lt;Location&gt;x-280 z 277&lt;/Location&gt;
      &lt;Info&gt;home and more stuff&lt;/Info&gt;
      &lt;Dayvisited&gt;125&lt;/Dayvisited&gt;
      &lt;userdata&gt;u&lt;/userdata&gt;
    &lt;/place&gt;
  &lt;/root&gt;
  </code></pre>
  
  <p>how can i make it return only those with Dayvisited less than 20 to the data grid?. i thought using textbox for the value was confusing something so i changed it to just use 20 and it still does it and i dont know why.</p>
  
  <p>how i add user input to the file </p>
  
  <pre><code>try
  {
  
  DataRow dr = ds.Tables[0].NewRow();
  dr["Name"] = Nametb.Text;
  dr["Location"] = Locationtb.Text;
  dr["Info"] = Infotb.Text;
  dr["Dayvisited"] = dayvisitcb.Text;
  dr["userdata"] = "u";
  ds.Tables[0].Rows.Add(dr);
  ds.WriteXml("Database.xml");
  
  }
  catch (Exception)
  {
  throw;
  }
  </code></pre>