how to show in asp.net grid total rows and actual rows without slowing the performance
<p>we have a asp.net1.1  3 tiers project in <strong>production</strong> .</p>

<p>right now for fetching data to asp.net grid, we have a constant call maxRows, and we don't fetch more than that (for performance reason).
we have a new request from the customer, "show me the num of total rows in the asp.net grid and the num of actual rows that have been fetch <strong>for each grid in the project</strong>."</p>

<p>between the presentation layer and the business layer we use .net remoting, and we are passing dataset between the tiers.</p>

<p>the database is ms sql server 2005.</p>

<p>we plan to upgrade this project to .net4.0</p>

<p>what is the solution for this request for .net1.1 and for .net4.0 ?</p>

<p>does asp.net grid have a built in feature to handle paging so we don't get outOfMemory exception for fetching a large amount of records ?</p>
