title: how to sum the column which is in the dataset and display in the footer
body: <p>Here is my code:</p>
  
  <pre><code>protected void Page_Load(object sender, EventArgs e)
  {
      if (!IsPostBack)
      {
          try
          {
              int IndexTypeID = 5;
              mobjORACLE = new DatabaseObjects.OracleDBCalls();
              DataSet dsetPortfolio = mobjORACLE.GetORACLEDataSet(IndexTypeID, "v_indextypeid", "cv_1", "fn_getportfolio");
  
              if (dsetPortfolio.Tables[0].Rows.Count &gt; 0)
              {
                  ViewState["gvPortfolio_DataSource"] = dsetPortfolio.Tables[0];
                  gvPortfolio.DataSource = dsetPortfolio.Tables[0];
                  gvPortfolio.DataBind();
                  gvPortfolio.Visible = true;
                  //dsetPortfolio.Tables[0].Rows[0]["cashreserve"];
  
                  //ViewState["gvPortfolio_DataSource"] = gvPortfolio.DataSource;
                  gvPortfolio.Attributes.Add("bordercolor", "#999966");
              }
          }
          catch (Exception ex)
          {
              throw ex;
          }
      }
  }
  </code></pre>
  
  <p>In gvPortfolio i got a datatable which has a column by name amount allocated. Now the question is, i need to sum up the column and display its result in the footer. Can somebody help me out in getting out of this.</p>