title: C# DataTable Count Number Of Rows In A Range
body: <p>I am trying to compute and count the number of rows inside a C# DataTable that are between a certain range.</p>
  
  <p>I would like the number(count) of rows where the value in the <strong>Responses</strong> column is between <strong>25 and 49</strong>. However I am not sure how to complete the following line of code.</p>
  
  <p>I am receiving the error <strong>"Operand &amp;&amp; cannot be applied to type 'string' and 'string'</strong>. I have tried converting the statement to Int32 but it still will not compile.
  How can I correctly type this statement?</p>
  
  <pre><code>// Populate datatable from the database.    
  answersDataTable = GetData.getIndividualQuestionResponsesOpenEndedAndRange(questionId);
  
  Int32 range25To49 = Convert.ToInt32(answersDataTable.Compute("COUNT(Response)", "Response &gt; '75'" &amp;&amp; "Response &lt; '50'"));
  </code></pre>