Display GridView Edit

Question

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,