title: How to get Total for a DataSet.DataTable on a GridView?
body: <p>I have a gridview that shows (50)rows of data per page.  I have the Total showing for the Amount that is shown due to a previous request by the user.  Now they want to have the total for the Entire result, regardless of what page they are on.  How do I do that?</p>
  
  <p>I did the following for my Complete Total Count:</p>
  
  <p>After the Gridview result gets populated in table</p>
  
  <pre><code>Count = dsReport.DataTable1.Count;
  </code></pre>
  
  <p>My plan for the Complete Total that has so far failed:</p>
  
  <pre><code>for (int i = 0; i &lt; Count; i++) 
  { Total += dsPoint.DataTable1.Columns[3].Row[i]; ??? I dont know what to do }
  </code></pre>
  
  <p>What is the sum of the specific Decimal Column[3]?  Even though I display 50 results, I need the Total for the ENTIRE column.</p>