calculate total price in grid view

Question

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!

s · Answer

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 { 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: function CalcSellPrice2(CurrentPrice QuntValue TotalValue) { var QuntVar = parseFloat(document.getElementById(QuntValue).value); var TotalVar = document.getElementById(TotalValue); var TotalPriceValue = parseFloat(CurrentPrice * QuntVar); TotalVar.innerHTML = TotalPriceValue; } how can I add to this code the calculation of total amount?

Dorababu Meka · Answer

Try this function. This was done a long time ago in my project. function multiplication(txtQuantity txtRate txtAmount) { var col1; var totalcol1 = 0; var weight = document.getElementById(txtQuantity).value; var rate = document.getElementById(txtRate).value; document.getElementById(txtAmount).value = weight * rate; var grid = document.getElementById(' '); // your grid name for (i = 0; i col1 = grid.rows[i].cells[4]; //col2 = grid.rows[i].cells[1]; for (j = 0; j if (col1.childNodes[j].type == text) { if (!isNaN(col1.childNodes[j].value) && col1.childNodes[j].value != ) { totalcol1 += parseInt(col1.childNodes[j].value) } } } } document.getElementById(' ').innerHTML = totalcol1.toFixed(2).toString(); } In page load after your grid bind add this for (int i = 0; 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

s · Answer

already tried this and its not working..

Dorababu Meka · Answer

check this sample with one grid http://dotnetspeaks.net/post/Display-Total-in-GridView-Footer-using-JQuery.aspx