title: Select a DataRow from a DataRow [] collection
body: <p>My code :</p>
  
  <pre><code>DataRow[] row = ByTotalTemplate.Select("TEMPLATE_ID=" + DisTemplateID);
  </code></pre>
  
  <p>A row contains <code>TEMPLATE_ID</code>,<code>MIN_AMOUNT</code>,<code>MAX_AMOUNT</code> and <code>DISCOUNT</code></p>
  
  <p>Now I want to select a row where a given amount is between <code>MIN_AMOUNT</code> and <code>MAX_AMOUNT</code></p>
  
  <p>I tried to do this :</p>
  
  <pre><code>DataRow amountRow = row.Select("MIN_AMOUNT&lt;" + quantity + " AND MAX_AMOUNT&gt;" + quantity);
  </code></pre>
  
  <p>but this didn't work.</p>