calculate total and grand total

Question

1.00/5 (2 votes)

See more:

i want to calculate total price and grand price from gridview values and from texbox for quantity.

i have a gridview and it has got 2 boundfield (description and price) and a textbox also. so i want to calculate total price based on price and entered quantity in that textbox and display it on the label inside the gridview

Posted 29-Aug-13 0:06am

Member 10239837

Updated 29-Aug-13 0:53am

v2

Add a Solution

Comments

muneebalikiyani 29-Aug-13 6:09am

Can't read your mind , what are u upto?

vinay.tatipamula 29-Aug-13 6:31am

Where are you struck? or you want us to write the code for you?

Member 10239837 29-Aug-13 6:41am

yes i would love you to write a code for me.

i wrote the code but it does not work

what i want exactly is that, i have a gridview with 2 boundfield, description and price and i also have a textbox(Qty) in that grid, so i want to calculate a total price for the entire row when you add a quantity to the textbox, i want it to calculate a total price and display it to the LAbel

[no name] 29-Aug-13 6:36am

Sure thing. You calculate the value by using the addition (+), subtraction (-), multiplication (*) and division (/) operators.

vinay.tatipamula 29-Aug-13 6:50am

:D

VishwaKL 29-Aug-13 7:00am

:)

Member 10239837 29-Aug-13 7:05am

and?

lukeer 29-Aug-13 7:15am

Now you start.
Or tell us where exactly the problem is.

Member 10239837 29-Aug-13 7:17am

what i want exactly is that, i have a gridview with 2 boundfield, description and price and i also have a textbox(Qty) in that grid, so i want to calculate a total price for the entire row when you add a quantity to the textbox, i want it to calculate a total price and display it to the LAbel

lukeer 29-Aug-13 7:53am

I know. You posted that thrice already.

What I don't know is: Whith what portion of that task do you have problems?

Member 10239837 29-Aug-13 7:58am

i want the code that will allow me to calculate the total price from qty and price and display a grand price

[no name] 29-Aug-13 8:14am

Ah... now we have the real problem. You would need to go to a site like www.vworker.com and hire someone to write code for you. We do not write code to order here.

Shobhana.n 29-Aug-13 7:33am

Why dont you use jquery or javascript to acheive this functionality.
Go through bellow link.
http://www.codeproject.com/Answers/642658/javascript-multiplication-in-Gridview-column#answer1

Member 10239837 29-Aug-13 7:42am

<asp:GridView ID="grdView" runat="server" GridLines="None" Font-Size="15pt"
Width="486px">

<columns>

<asp:TemplateField HeaderText="Quantity">
<itemtemplate>
<asp:TextBox ID="txtQty" runat="server" Height="16px" Width="38px">

<asp:TemplateField HeaderText="Total Price">
<itemtemplate>
<asp:Label ID="lblTotalPrice" runat="server" Text="0">

Member 10239837 29-Aug-13 7:44am

so i have these 2 gridview, one gridview reads data from the sql database, and you select the checkbox and it goes to another gridview(grdView) and from there you add a quantity in the textbox...so i need that javascript code to calculate that, when you entered your quantity, it must display the total price in the lblTotal

3 solutions

Solution 3

> i want the code that will allow me to calculate
> the total price from qty and price and display a grand price

C#

int quantity = 3;
decimal price = 41.99;

decimal totalPrice = price * quantity;

// jokeInCode: I have no idea what a grand price is. Something similar to the Laguna Seca Grand Prix?
// Jokes aside, is it something with a tax?

decimal tax = 0.073;

decimal grandPrice = totalPrice * (1 + tax);

Posted 29-Aug-13 2:13am

lukeer

Solution 2

XML

<asp:GridView ID="grdView" runat="server"  GridLines="None" Font-Size="15pt"
        Width="486px">



            <asp:TemplateField HeaderText="Quantity">

                    <asp:TextBox ID="txtQty" runat="server" Height="16px" Width="38px">




            <asp:TemplateField HeaderText="Total Price">

                    <asp:Label ID="lblTotalPrice" runat="server" Text="0">

Posted 29-Aug-13 1:45am

Member 10239837

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)

Anele Ngqandu · Accepted Answer · 2013-08-29T02:49:00

Hi this is how I did mine but was calculating KM's

C#

double tot = 0;
int _count = 0;
decimal _sumKillometers = 0.0M;

C#

protected void grvTravelClaims_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                Label lblKM = (Label)e.Row.FindControl("lblKillometers");
                decimal _Killometers = Decimal.Parse(lblKM.Text);
                _sumKillometers += _Killometers;
                _count += 1;
            
            }
            if (e.Row.RowType == DataControlRowType.Footer)
            {
                Label lblKM = (Label)e.Row.FindControl("lblTot");
             
                double rate=Convert.ToDouble(txtRate.Text);
                double sum=Convert.ToDouble(_sumKillometers);
             
                lblKM.Text = (rate * sum).ToString();
                
            }
        }

Then thats how I called my event in the gridview

ASP

OnRowDataBound="grvTravelClaims_RowDataBound"