How to sum of value in gridview select data from database in asp.net

Question

AVADHESH PATEL · Answer

Hi Takeshi!You can try as followingyou have to write the code in RowDataBound Event of gridview.I am posting a sample code for your reference try it yourselfprotected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e){ if (e.Row.RowType == DataControlRowType.DataRow) { Label lblPrice = (Label)e.Row.FindControl("lblPrice"); Label lblUnitsInStock = (Label)e.Row.FindControl("lblUnitsInStock"); decimal price = Decimal.Parse(lblPrice.Text); decimal stock = Decimal.Parse(lblUnitsInStock.Text); totalPrice += price; totalStock += stock; totalItems += 1; } if (e.Row.RowType == DataControlRowType.Footer) { Label lblTotalPrice = (Label)e.Row.FindControl("lblTotalPrice"); Label lblTotalUnitsInStock = (Label)e.Row.FindControl("lblTotalUnitsInStock"); lblTotalPrice.Text = totalPrice.ToString(); lblTotalUnitsInStock.Text = totalStock.ToString(); lblAveragePrice.Text = (totalPrice / totalItems).ToString("F"); }}I hope it resolve your problem

forum

How to sum of value in gridview select data from database in asp.net

Can you answer this question?

1 Answers