How do get sum row and column data grid view ...

Question

Hi how do get pay of product (*) of rows and ... sum columns from data grid view ... then show in textBox ? like this pic !

Saber Shaikh · Answer

int Sum=0; foreach (GridViewRow gr in GridView1.Rows) { Sum= Sum+ int.Parse(gr.Cells[1].ToString()));// columns [] inext } TextBox1.Text = Sum.ToString(); Blog : http://aspnettutorialscode.blogspot.in/

Syed Shanu · Answer

When you bind the data you can calulate the Datatable Coulm Sum value and display the result in Textbox.Check this link. http://stackoverflow.com/questions/5892993/how-to-calculate-the-sum-of-the-datatable-column-in-asp-net

Pankaj Kumar Choudhary · Answer

Hello @Ghasem you can use this metod protected void Button1_Click(object sender EventArgs e) { int Sum=0; foreach (GridViewRow gr in GridView1.Rows) { Sum+= int.Parse(gr.Cells[1].ToString()) * int.Parse(gr.Cells[2].ToString()); } TextBox1.Text = Sum.ToString(); }

ghasem deh · Answer

thanks dear Pankaj ; butt i don't use Button_Click ! when Rows Full ... Get Sum in textBox