title: ASP.NET c# adding row to dataset
body: <p>i have a dataset which im using to calculate some sales figures, this data set has about 15 columns i want to add a new row to the end of the dataset to calculate the total of each column. heres an example of what the dataset looks like</p>
  
  <pre><code>NAME | GP   | ORD_GP | EXP   | TOTAL GP
  a      206     48      -239     15 
  b      0       27       0        27
  </code></pre>
  
  <p>so what i want to be able to do is add another row at the end which will calulate the sum of each row so it would look something like</p>
  
  <pre><code>NAME | GP   | ORD_GP | EXP   | TOTAL GP
  a      206     48      -239     15 
  b      0       27       0       27
  TOTAL  206     75       -239    42
  </code></pre>
  
  <p>so far i have </p>
  
  <pre><code>    ds.Tables[0].Rows.Add("TOTAL");
      foreach (DataColumn dc in ds.Tables[0].Columns)
      {
        // add upp column data and put into toal field
      }
  </code></pre>