Show total in Gridview's footer, w/o template or bounded

Question

Hi All,

I want to show total in gridview's footer. If I had template field or bounded field in my gridview I could have done it before but in my scenario it's different.

I need to show total for all columns except the first column because it doesn't have integer it's a string.

Below is my gridview.

<asp:GridView ID="GVReport" runat="server" Width="1200px" CellPadding="4" EnableModelValidation="True" AllowPaging="True" onpageindexchanging="GVEmployee_PageIndexChanging" ForeColor="#333333" GridLines="None" ondatabound="GVReport_DataBound" onrowdatabound="GVReport_RowDataBound" ShowFooter="True"> 
<AlternatingRowStyle BackColor="White" /> 
<FooterStyle BackColor="#507CD1" ForeColor="White" Font-Bold="True" /> 
<HeaderStyle BackColor="#006666" ForeColor="White" Font-Bold="True" /> 
<PagerStyle BackColor="#006666" ForeColor="White" HorizontalAlign="Center" /> 
<RowStyle BackColor="#ffcc00" /> <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" /> 
</asp:GridView>

and here I am binding the gridview

protected void Bind_Grid()
{
DateTime Date; DateTime.TryParseExact(lblDate.Text, "dd/MM/yyyy", new CultureInfo("en-US"), DateTimeStyles.None, out Date); 
Business_Logic bal = new Business_Logic();
DataTable dt = new DataTable();
dt = bal.TMS_Report(Date.Date, lblEmpCode.Text);
if (dt.Rows.Count > 0)
{
GVReport.DataSource = dt;
GVReport.DataBind();
GVReport.Visible = true;
}
}

Gridview is binding perfectly. Hpw can I show the total in footer?

see my bounded gridview in below image