I have table like below...........
| S.no | Items | Opening | Purchase | Total1 | Balcony | II counter | III | Total2 | Balance | Sold | Amount | Rate |
| 1) | Chips | 10 | 15 | 25 | 10 | 5 | 5 | 5 | 2 | 3 | 30.00 | 10 |
| 2) | Popcorn | 10 | 3 | 13 | 2 | 3 | 3 | 5 | 2 | 3 | 15.00 | 5 |
when i purcase chips add in purchase coloum in date wise
ex:
when i purchase 20 items add in purchase 15+20=35 in purchase coloum date wise
.....
when i transevered items balcony ,2 counter ,3 counter display in total
total1-balcony-2counter-3rdcounter=tatal2
.........
sold=total-balence
i want display in gridview in edit perticular coloums like opening balcony,1counter,3rdcounter,balence,amount,