calculate total price in grid view

14y9.5k.NET

Hello,

I have a grid view that bind data from other grid view (from other page) and I want the user to be able to insert quantity and then to calculate the total price.

how can I do that?

i've tried this example:

http://www.c-sharpcorner.com/blogs/7857/calculate-total-price-on-textbox-change-event.aspx

and its great but missing the grand total. how can I calculate the grand total and display it both on grid view and label?

thanks!

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

s14y ago
I already have the calculate of the total of each row.
I want to calculate the total of all the totals..

my code is:
public DataSet GetData()
{
DataSet ds = new DataSet();
DataTable dt = new DataTable("Product");
DataRow dr;
dt.Columns.Add(new DataColumn("Price", typeof(Int32)));
dt.Columns.Add(new DataColumn("Qut", typeof(Int32)));
dt.Columns.Add(new DataColumn("TotalPrice", typeof(Int32)));

for (int i = 1; i <= 10; i++)
{
dr = dt.NewRow();
dr[0] = (20 * i);
dt.Rows.Add(dr);
}
ds.Tables.Add(dt);
Session["dt"] = dt;
return ds;
}

protected void GridView2_RowDataBound(object sender, GridViewRowEventArgs e)
{

if (e.Row.RowType == DataControlRowType.DataRow)
{
Label lblCurrentListPrice = (Label)e.Row.FindControl("lblCurrentListPrice");
Double CurPr = Convert.ToDouble(lblCurrentListPrice.Text);
TextBox txtqut = (TextBox)e.Row.FindControl("txtqut");
Label lblTotal = (Label)e.Row.FindControl("lblTotal");
txtqut.Attributes.Add("onkeyup", "CalcSellPrice2(" + CurPr + ", '" + txtqut.ClientID + "','" + lblTotal.ClientID + "')");

}

}

and I have this JS:

how can I add to this code the calculation of total amount?

0
Dorababu Meka14y ago
Try this function. This was done a long time ago in my project.

In page load after your grid bind add this

for (int i = 0; i < grdInvoice.Rows.Count; i++)
{
TextBox curTexbox = grdInvoice.Rows[i].Cells[1].FindControl("txtQuantity") as TextBox;
TextBox curTexbox1 = grdInvoice.Rows[i].Cells[3].FindControl("txtRate") as TextBox;
TextBox curTexbox2 = grdInvoice.Rows[i].Cells[4].FindControl("txtAmount") as TextBox;

curTexbox.Attributes.Add("onBlur", "return multiplication('" + curTexbox.ClientID + "','" + curTexbox1.ClientID + "','" + curTexbox2.ClientID + "')");
}

Rename with your controls here

This will work when you are trying to add or edit the quantity or Rate value
0
s14y ago
already tried this and its not working..
0
Dorababu Meka14y ago
check this sample with one grid

http://dotnetspeaks.net/post/Display-Total-in-GridView-Footer-using-JQuery.aspx
0