title: How to filter datagridview rows between range?
body: <p>i have a column called copy number which contains only numbers like so:</p>
  
  <pre><code>copy number
   1
   33
   12
   40
   100
  </code></pre>
  
  <p>how can i get rows between <strong>1</strong> and <strong>100</strong> Range which is in this example are rows (33, 12, 40)?</p>
  
  <p>my data is from mysql database and the GridView is populated like this:</p>
  
  <pre><code>MySqlDataAdapter a = new MySqlDataAdapter(query, conn)
  DataTable t = new DataTable();
  a.Fill(t);
  dataGridView1.DataSource = t;
  </code></pre>
  
  <p><strong>PS</strong>: answers in code will be much appreciated!</p>