forum

Home / DeveloperSection / Forums / How to sum of value in gridview select data from database in asp.net

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

Takeshi Okada213709-May-2013

Hi!

I want to display PF and ESI value from basic salary and total PF and ESI in gridview footer in Indian currency.

Please help me asap.

Thanks in advance!

Updated on 09-May-2013

Can you answer this question?

Answer

09-May-2013

Hi Takeshi!

You can try as following

you have to write the code in RowDataBound Event of gridview.

I am posting a sample code for your reference try it yourself

protected 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