title: Determine if a sql request returns zero records in asp.net application
body: <p>I have an asp.net application which requests my database, everything is working, but I would just like to know how can I know from the oracle reader the number of requests found by the request.</p>
  
  <p>This is my code :</p>
  
  <pre><code>            OracleCommand command = connection.CreateCommand();
              string sql = "SELECT MYTABLE.MYFIELD FROM MYTABLE";                
              command.CommandText = sql;
              OracleDataReader reader = command.ExecuteReader();
              // 
              while (reader.Read())
              {
  
              }
  </code></pre>
  
  <p>Does the reader have a propriety showing the number of records found from the request?</p>
  
  <p>Thanks in advance for your help.</p>