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;
}