title: Displaying Total in Footer of GridView and also Add Sum of columns(row vise) in last Column
body: <p>In my Asp.net App, i have a <code>GridView</code> and i generate the data of <code>column[6]</code> by myself using code behind.</p>
  
  <p>by looking at the code below, i have a <code>footer</code> for my <code>gridview</code>. and the problem is my text for column[6] won't appear if i use footer. 
  If i delete the footertext code, then my text for column[6] is appear. what is the problem? both of the code cant use togather? i already set  ShowFooter="True"</p>
  
  <pre><code>protected void Page_Load(object sender, EventArgs e)
  {
      for (int i = 0; i &lt; (this.GridView1.Rows.Count); i++)
      {
         this.GridView1.Rows[i].Cells[6].Text = "testing";
         //GridView1.Columns[1].FooterText ="footer 1";
      }
  }
  </code></pre>
  
  <p>.aspx</p>
  
  <pre><code>&lt;asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1" 
              AutoGenerateColumns="False" DataKeyNames="ID" CellPadding="4" 
              ForeColor="#333333" GridLines="None" ShowFooter="True" 
                      onrowdatabound="GridView1_RowDataBound"&gt;
              &lt;RowStyle BackColor="#EFF3FB" /&gt;
              &lt;Columns&gt;
                  &lt;asp:BoundField DataField="reportDate" HeaderText="Report Date" dataformatstring="{0:dd MMMM yyyy}" SortExpression="reportDate" /&gt;
                  &lt;asp:BoundField DataField="sponsorBonus" HeaderText="Sponsor Bonus"  dataformatstring="{0:0.00}" SortExpression="sponsorBonus" HtmlEncode="False" /&gt;
                  &lt;asp:BoundField DataField="pairingBonus" HeaderText="Pairing Bonus" HtmlEncode="False" SortExpression="pairingBonus" dataformatstring="{0:c}" /&gt;                                       
                  &lt;asp:BoundField DataField="staticBonus" HeaderText="Static Bonus"  SortExpression="staticBonus" /&gt;
                  &lt;asp:BoundField DataField="leftBonus" HeaderText="Left Bonus"  SortExpression="leftBonus" /&gt;
                  &lt;asp:BoundField DataField="rightBonus" HeaderText="Right Bonus"  SortExpression="rightBonus" /&gt;
                  &lt;asp:BoundField HeaderText="Total" SortExpression="total" &gt;
                  &lt;ItemStyle Width="100px" /&gt;
                  &lt;/asp:BoundField&gt;
              &lt;/Columns&gt;
              &lt;FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" /&gt;
              &lt;PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" /&gt;
              &lt;SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" /&gt;
              &lt;HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" /&gt;
              &lt;EditRowStyle BackColor="#2461BF" /&gt;
              &lt;AlternatingRowStyle BackColor="White" /&gt;            
          &lt;/asp:GridView&gt;
  </code></pre>