on behalf of this article :
http://codedisplay.com/show-grand-total-running-total-sub-total-in-asp-net-gridview-footer-c-vb-net/
lets assume i have four columns
| Sr |
Company |
Date |
Billing amount |
| 1 |
Imtiaz Super Market |
11/12/1991 |
2000 |
| 2 |
Naheed mart |
11/12/1991 |
4000 |
| 3 |
Imtiaz Super Market |
11/12/1991 |
3000 |
now it must group by the company name and show running total and net total like :
| Sr |
Company |
Date |
Billing amount |
| 1 |
Imtiaz Super Market |
11/12/1991 |
2000 |
| 2 |
Imtiaz Super Market |
11/12/1991 |
3000 |
| |
|
|
5000 |
| 3 |
Naheed mart |
11/12/1991 |
4000 |
| 4 |
Naheed mart |
11/12/1991 |
5000 |
| |
|
|
9000 |
| |
|
|
14000 |
NOTE : it must support paging and must be binded with data table