Hi,
Display the total value in gridview footer without using template field. this is the example that i want to display 
loc 29/12  28/12 27/12 26/12 25/12...etc
1      0        0       0        0      1
2      0        4       0        0      2
3      0        0       1        5      0
4      0        0       1        0      0
5      2        0       0        4      1
6      0        0       3        1      0
Total:2       4        4        9      4
footer values i want to display like this, in the row 29/12 28/12 27/12 this are dynamically generated, depends on the month. this is the code i have used.
 In this code i am getting syntax error in line 07. 
int total = 0; ;
GridView1.FooterRow.Cells[0].Text = "Total";
GridView1.FooterRow.Cells[1].Font.Bold = true;
GridView1.FooterRow.Cells[1].HorizontalAlign = HorizontalAlign.Left;
for (int k = 1; k < dt.Columns.Count - 1; k++)
{
    total = dt.AsEnumerable().Sum(row => row.Field<Int32>(dt.Columns[k].ToString()));
    GridView1.FooterRow.Cells[k].Text = total.ToString();
    GridView1.FooterRow.Cells[k].Font.Bold = true;
    GridView1.FooterRow.BackColor = System.Drawing.Color.Beige;
}