title: Rows number of SqlDataReader
body: <p>I'm trying to get rows count of <strong>SqlDataReader</strong> with SQL <code>COUNT()</code>. Because of some technical reasons I can't use a counter (increasing a variable while going forwarder). It's my SQL Statement:</p>
  
  <pre><code>(SELECT * FROM [Menus] WHERE MenuParent=@ID);
  (SELECT COUNT(*) AS rowsCount FROM [Menus] WHERE MenuParent=@ID)
  </code></pre>
  
  <p>And it's my .net code: <br/>
  <em>(It's simple, C#ers can understand it also)</em></p>
  
  <pre><code>While DR.Read
      If Not DR("rowsCount") Is Nothing Then
      temp &amp;= DR("rowsCount")
      End If
      'blah blah
  End While
  </code></pre>
  
  <p>It does not recognize <strong>rowsCount</strong>.</p>
  
  <p>What's my wrong?</p>
  
  <p>Whole function: (I used my own classes to connect to the DB) <a href="http://pastebin.com/YBZCvvBH" rel="nofollow">http://pastebin.com/YBZCvvBH</a></p>