gd mrng,
 
i need to insert  row in asp.net gridView, the output should be as shown below :
 
          
|  | 
|  | 
|  |  |  |  |  | 
| SR.NO |  | ACCOUNT NAME | DATE | NARRATION | DEBIT AMOUNT | CREDIT AMOUNT | BALANCE | DR/CR | CITYNAME | 
| 1 |  | HAPPY KARYANA STORE. | 30-06-2012 | To Bill No.:-  VAT-1   Dated : 30/06/2012 | 970.00 |  | 970.00 | Dr | SANGRUR | 
|  |  | Total |  |  | 970.00 |  | 970.00 |  |  | 
| 2 |  | ROUND OFF | 30-06-2012 | To Bill No.:-  VAT-1  30/06/2012 | 0.19 |  | 0.19 | Dr | NONE | 
|  |  | Total |  |  | 0.19 |  | 0.19 |  |  | 
| 3 |  | SALE VAT 12.5% | 30-06-2012 | By Bill No.:-  VAT-1   Dated : 30/06/2012 |  | 862.39 | 862.39 | Cr | NONE | 
|  |  | Total |  |  |  | 862.39 | 862.39 |  |  | 
| 4 |  | VAT OUTPUT 12.5% | 30-06-2012 | By Bill No.:-  VAT-1   Dated : 30/06/2012 |  | 107.80 | 107.80 | Cr | NONE | 
|  |  | Total |  |  |  | 107.80 | 107.80 |  |  | 
|  |  | G.Total |  |  | 970.19 | 970.19 |  |  |  | 
here the total is the row that i want to add, hw can i do this, please help
 
Thanks.