title: how to count the total number of row in oledbconnection in c#.net
body: <p>how to count the total number of row in oledbconnection in c#.net</p>
  
  <p>I want to count how many rows are present in my table.</p>
  
  <pre><code>                string dataReader = "SELECT count(*) from `Email_account_list`";
                  OleDbCommand command_reader = new OleDbCommand(dataReader, myConnection);
                  OleDbDataReader row_reader = command_reader.ExecuteReader();
  </code></pre>
  
  <p>What function i will write to fetch total number of rows present in table.</p>