C# 2013, Deduct total amount upto paying everytime

Question

I need to load datasource from database tabel to show on datagridview and in the datagrideview I have colum Col1 called Pay/time and col2 called amount. I want to minus Col2 to Col1 in Row0 and Col2 in row2 would be the sum of row0 or: this code just working when the datagridview load or fill Col1 Col2 1,000 - 10,000 = 9,000 1,000 - 9,000 = 8,000 1,000- 8,000 = 7,000 1,000 - n 1,000 -0 0 something like that. I do not know how to say in English well but I hope understand how to do it I just can do Like Col1 Col2 1,000 10,000 1,000 10,000 1,000 10,000 it keeps the same amount Advance thanks Agently need it.

Rajneesh Chaubey · Answer

Hi @Sai, I coudn't get your question. Do you want to say that there are two columns in same table and you want to calculate difference between them and show in gridview? If it is like that you can simply calculate difference in your sql query by this:- SELECT *,col2-col1 AS Difference FROM SampleTable Now bind the result in gridview from above query. Hope you get it. Thanks.

Sai Yang · Answer

Sorry my English is not strong enough, but I hope you understand what I mean and today I resay above question again. in my case. I build a graduate project for a car company like selling car and I need to calculate the price. For exsample the car price is 25,000$ customer need to pay in 12 months by paying every month. so my textboxprice=25,000$ my textboxterm=12. it also has interest but here I skip saying because I calculated and I need to deduct the amount after paying everytime. amount to pay per time is textboxprice/textboxterm = 2083.33$. After textboxterm change , the gridview1 gets detail from deviding price(I got it). sample col. col-term col-price-per-term col-left-amount 1 2083.33 25,000 2 2083.33 22,916.67 3 2083.33 20,833.34 . - - . - - . - - 12 2083.33 2083.33 finish pay in the last term. the gridview just get value from deviding textbox and calculatting; it does not select from any database or tabel. I did the col1 and col2 but did not done the col3 or col left amount any other idia? Thank so much.