how to retrive price and quantity from gridview and how to calculate totalprice in asp.net

Question

1.00/5 (1 vote)

See more:

Can anyone help?

how to retrive price and quantity from gridview and show it in footer also & how to calculate totalprice in asp.net

C#

protected void totalprice()
    {
        int quantity = int.Parse("txtquantity");
     float price =float.Parse("price");
     float totalprice = float.Parse("totalPrice");
     totalprice=quantity * price;
}

is thi correct?

Posted 2-Dec-11 18:18pm

sathiyak

Updated 2-Dec-11 18:29pm

v2

Add a Solution

Comments

Karthik Harve 3-Dec-11 0:24am

what are those price and quantity..? are they row values, column values..?? do you want calculate total price at the footer of gridview..?? be specific and add some code, if you have tried something.

sathiyak 3-Dec-11 1:53am

row values........yes i want to calculate totalprice but not in footer outer grid....

Prince Antony G 3-Dec-11 2:13am

why u repost the question again and again?

sathiyak 3-Dec-11 2:30am

helo...i m not reposting.....

3 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)

S.P.Tiwari · Answer 1 · 2011-12-02T19:57:00

C#

function calculateGridTotal() {  // call this on body load

        var tmpgvRenewal = document.getElementById("gvRenewal");  // this is the gridis
        var Price = 0.0;
var Quantity = 0.0;
var TotalPrice = 0.0;
        var arrstr = tmpgvRenewal.id + "_ctl";

        for (var i = 2; i <= tmpgvRenewal.childNodes[0].childNodes.length - 1; i++) {   //search for all row of grid view and calculate whatever you want
            if (parseInt(i) < 10) {
                var c = "0" + i;
            }
            else {
                var c = i;
            }
            var lblQuantity = document.getElementById(arrstr + c + "_lblQuantity").innerHTML;
            var lblPrice= document.getElementById(arrstr + c + "_lblPrice").innerHTML;

            lblQuantity= lblQuantity.replace(/,/g, '');  // if that value is like(100,000,00)
            lblPrice = lblPrice.replace(/,/g, '');


            if (lblQuantity != "")
                Quantity = Quantity + parseFloat(lblQuantity);

            if (lblPrice!= "")
              Price = Price + parseFloat(lblPrice);

        }

TotalPrice = Price * Quantity;
        tmpgvRenewal.rows[tmpgvRenewal.rows.length - 1].cells[2].innerHTML = Quantity;   // assign it to footer row of grid(make footer row visible = true) (Total Quantity)
        tmpgvRenewal.rows[tmpgvRenewal.rows.length - 1].cells[3].innerHTML = Price;
        tmpgvRenewal.rows[tmpgvRenewal.rows.length - 1].cells[4].innerHTML = TotalPrice;

    }

try this java script. to calculate total of grid element and assin into footer.

uspatel · Answer 2 · 2011-12-02T18:50:00

make AutoGenerateSelectButton=true,
on rowcommand of gridview

C#

protected void fect_taskid(object sender, GridViewCommandEventArgs e)
   {
               int index = Convert.ToInt32(e.CommandArgument);
               GridViewRow row = GridView1.Rows[index];
               string pr = row.Cells[1].Text;//1 will be the index of Price
               string qt=row.Cells[2].Text;
               float lbltotalprice=float.Parse(int.Parse(qt)*float.Parse(pr))
   }

S.P.Tiwari · Answer 3 · 2011-12-02T20:07:00

you can do like this .

C#

Protected void Totalprice()
{
    foreach(GridViewRow gvRow in GridViewName.Rows)
    {
        int Quantity = Convert.ToInt32(((TextBox)gvRow.FindControl("txtquantity")).Text)
        int Price = float.tryParse(((Label)gvRow.FindControl("lblPrice")).Text)
    float TotalPrice = Quantity * Price;

    // find here footer Control of gridview and set the value.
    // first you have to make sure ShowFooterRow is true

    lblFooterTotalPrice = (Label)gvrow.FindControl("lblfootertotalPrice");
    lblFooterTotalPrice.Text = TotalPrice;
    }

}

how to retrive price and quantity from gridview and how to calculate totalprice in asp.net

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0