How to get dynamic Gridview textbox template column value sum

Question

5.00/5 (1 vote)

See more:

Hello Friends,

i have create an dynamic grid view with 3 text box named 1) item name, 2)qty , 3)price. now i want to get Total of all the price text box in label.

here is code for dynamic add new row in gridview :-

C#

private void AddNewRowToGrid()
    {
        try
        {
            int rowIndex = 0;

            if (ViewState["CurrentTable"] != null)
            {
                DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"];
                DataRow drCurrentRow = null;
                if (dtCurrentTable.Rows.Count > 0)
                {
                    for (int i = 1; i <= dtCurrentTable.Rows.Count; i++)
                    {
                        //extract the TextBox values
                        TextBox box1 = (TextBox)GrdProduct.Rows[rowIndex].Cells[1].FindControl("txtitemname");
                        TextBox box2 = (TextBox)GrdProduct.Rows[rowIndex].Cells[2].FindControl("txtqty");
                        TextBox box3 = (TextBox)GrdProduct.Rows[rowIndex].Cells[3].FindControl("txtprice");

                        drCurrentRow = dtCurrentTable.NewRow();

                        drCurrentRow["RowNumber"] = i + 1;
                        drCurrentRow["Column1"] = box1.Text;
                        drCurrentRow["Column2"] = box2.Text;
                        drCurrentRow["Column3"] = box3.Text;

                        rowIndex++;
                    }
                    dtCurrentTable.Rows.Add(drCurrentRow);
                    ViewState["CurrentTable"] = dtCurrentTable;

                    GrdProduct.DataSource = dtCurrentTable;
                    GrdProduct.DataBind();
                }
            }
            else
            {
                Response.Write("ViewState is null");
            }

            //Set Previous Data on Postbacks
            SetPreviousData();
        }
        catch (Exception ex)
        {
            lblerror.Visible = true;
            lblerror.InnerText = ex.Message.ToString();
        }
    }

now i want Total of all the Price in one Label when textbox_changed event fire.

Thanx to all...!!!!

Posted 15-Aug-12 4:06am

Yatin chauhan

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

veenusethi · Answer 1 · 2012-08-16T01:43:00

C#

function calculateamount() {
      var txtTotal = 0;
        var passed = false;
        total = 0.00;
        var id = 0;
        totalDTH = 0.00;
        totalMCF = 0;
        // Get the gridview
        var grid = document.getElementById("<%= GridView1.ClientID%>");
       
        // Get all the input controls (can be any DOM element you would like)
        var inputs = grid.getElementsByTagName("input");
        
        // Loop through all the DOM elements we grabbed
        for (var i = 0; i < inputs.length; i++) {
            // In this case we are looping through all the Dek Volume and then the Mcf volume boxes in the grid and not an individual one and totalling them
            if (inputs[i].name.indexOf("lbl_amt") > 1) {
                if (inputs[i].value != "") {
                    totalDTH = totalDTH + MathRound(parseFloat(inputs[i].value));
                }
            }
        }
        document.getElementById("<%= txtamttotal.ClientID %>").value = MathRound(totalDTH);
        
    }

if (inputs[i].name.indexOf("lbl_amt") > 1) // You should use here textbox of price which is in gridview.

call calculateamount() function on keyup or onblur

please vote if it helps you thanks

Anuja Pawar Indore · Answer 2 · 2012-08-16T02:54:00

Solution 2

Refer this threads
http://stackoverflow.com/questions/11951511/how-can-i-make-a-sum-for-rows-total-value[^]
http://stackoverflow.com/questions/6907306/gridview-textboxes-column-sum-using-jquery[^]

Posted 16-Aug-12 2:54am

Anuja Pawar Indore