how to calculate gridview column total in Textbox in windows

Question

how to calculate gridview column Unit total, Amount Total,TaxAmount Total and TotalAmount Total in Textboxs in windows application

Rafnas T P · Answer

for this after binding data, you have to loop this grid and add column for example if your grid name is dataGridView then decimal unit_ttl= 0; decimal amouttotal= 0; decimal taxtotal = 0; decimal totalamount = 0; for (int i = 0; i { unit_ttl= unit_ttl+ Convert.ToDecimal(dataGridView.Rows[i].Cells[4].Value); amouttotal= amouttotal+ Convert.ToDecimal(dataGridView.Rows[i].Cells[5].Value); totalamount = totalamount+ Convert.ToDecimal(dataGridView.Rows[i].Cells[6].Value); taxtotal = taxtotal + Convert.ToDecimal(dataGridView.Rows[i].Cells[7].Value); } TotalUnittxt.Text = unit_ttl.ToString(); amounttxt.Text = amouttotal.ToString(); TotalTaxtxt.Text = taxtotal.ToString(); totalamounttxt.Text = totalamount.ToString();

Jyoti Jodha · Answer

my applicatiuon is Windows Application Not Web Application.....

Manas Mohapatra · Answer

Follow below links that may help you: http://www.c-sharpcorner.com/UploadFile/rohatash/adding-values-in-column-and-sum-of-the-column-values-in-grid/ https://www.aspsnippets.com/Articles/Display-sum-of-Columns-total-in-GridView-Footer-in-ASPNet-using-C-and-VBNet.aspx http://www.c-sharpcorner.com/UploadFile/8c19e8/how-to-do-calculations-in-gridview/

how to calculate gridview column total in Textbox in windows

Answers (3)