Gridview GrandTotal On Top of Gridview .?

Karthik K

Hi All ,

I want to have the GrandTotal value on the Top of the Gridview in asp.net . Normally we do GrandTotal and and subtotal in Footer . But i require it on header of the Gridview. If anyone know this , suggest me with example.

Thanks in Advance ,

Karthik K

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar6y ago
Hi Karthik,

You can do in same way as footer grand total. Just you need to change control finding header instead of footer. Please find below link,
https://www.aspsnippets.com/Articles/Display-sum-of-Columns-total-in-GridView-Footer-in-ASPNet-using-C-and-VBNet.aspx
Laxmidhar Sahoo6y ago
1. public decimal grandtotal = 0;
2. protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
3. {
5. if(e.Row.RowType==DataControlRowType.DataRow)
6. {
8. if(e.Row.Cells[3] != null)
9. {
10. grandtotal += Convert.toDecimal(e.Row.Cells[3].Text);
11. }
12. }
13. }
15. GridView1.Columns(3).HeaderText = Convert.toString(grandtotal);

Rajanikant Hawaldar6y ago

Hello Karthik,in the RowDataBound for footer, you can do FindControl on the HeaderRow of the GridView to find Labels in the Header. Then you can set the values of these

foreach (GridViewRow gvr in GridView4.Rows) {
if (gvr.RowType == DataControlRowType.DataRow) {
decimal fee = Convert.ToDecimal(gvr.Cells(5).Text);
feeFooter += fee;
}
}
GridView4.Columns(3).HeaderText = feeFooter;