How to multiplication of two column in gridview in Asp.Net C#

Question

1.00/5 (2 votes)

See more:

XML

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
                onselectedindexchanged="GridView1_SelectedIndexChanged" Width="100%">
            <Columns>
                <asp:TemplateField HeaderText="Sr No" >
                <ItemTemplate>
                <asp:Label ID="lblSerial" runat="server"></asp:Label>
                </ItemTemplate>
                </asp:TemplateField>
                <asp:BoundField HeaderText="Description" DataField="Description"
                    ItemStyle-Width="50%" >
<ItemStyle Width="50%"></ItemStyle>
                </asp:BoundField>
                <asp:BoundField HeaderText="Quantity" DataField="Quantity"
                    ItemStyle-Width="10%" >
<ItemStyle Width="10%"></ItemStyle>
                </asp:BoundField>
                <asp:TemplateField HeaderText="Rate Per Unit">
                    <ItemTemplate>
                        <asp:TextBox runat="server" Width="95%" ItemStyle-Width="15%" ID="txtRatePerUnit" OnTextChanged="txtRatePerUnit_TextChanged" AutoPostBack="true"></asp:TextBox>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Total Amount">
                    <ItemTemplate>
                        <asp:Label runat="server" ID="lblTotalAmount"  ItemStyle-Width="15%"></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>

            </Columns>
            </asp:GridView>

Posted 9-Nov-13 17:05pm

pravin_kale

Add a Solution

Comments

pravin_kale 9-Nov-13 23:15pm

In This code i have to calculate particular column total in his textchang event Sr No,Description,Quantity this prev database field
i have to do multiplication of Quantity and Rate Per Unit in txtRatePerUnit txtchange event answer show in lblTotalAmount
Pls Tel me Solution

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 10-Nov-13 9:30am

What have you tried?

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)

pravin_kale · Answer 1 · 2013-11-11T21:52:00

Thanks So much Giving me this good Solution
I am finding another code if anybody want this solution They Can Use My following code

protected void txtRatePerUnit_TextChanged(object sender, EventArgs e)
{
int ind = ((sender as TextBox).NamingContainer as GridViewRow).RowIndex;
int latInd = GridView1.Rows.Count;
Int64 cnt = 0;
TextBox txtRatePerUnit = (TextBox)GridView1.Rows[ind].Cells[3].FindControl("txtRatePerUnit");
// TextBox percentage = (TextBox)gVAppraisal.Rows[((sender as TextBox).NamingContainer as GridViewRow).RowIndex].Cells[2].FindControl("txtPercentage");
Label lblTotalAmount = (Label)GridView1.Rows[ind].Cells[4].FindControl("lblTotalAmount");
if ((txtRatePerUnit.Text.Equals(string.Empty)))
txtRatePerUnit.Text = "0";
lblTotalAmount.Text = (Int32.Parse(txtRatePerUnit.Text) * (Int32.Parse(GridView1.Rows[ind].Cells[2].Text))).ToString();

foreach (GridViewRow r in GridView1.Rows)
{
Label lbl = (Label)r.Cells[4].FindControl("lblTotalAmount");
if (!(lbl.Text.Equals(string.Empty)))
cnt += Convert.ToInt64(lbl.Text);
}
TextBox7.Text = cnt.ToString();

}

anurag19289 · Answer 2 · 2013-11-10T09:02:00

i guess this is what you are looking for. Accept it as answer if it helped you

C#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Text;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {

            string strcon = ConfigurationManager.ConnectionStrings["ConnectionStringdb"].ConnectionString;
            using (SqlConnection con = new SqlConnection(strcon))
            {

                SqlCommand cmd = new SqlCommand("USP_datamanipulation", con);
                cmd.CommandType = CommandType.StoredProcedure;

                con.Open();
                GridView1.DataSource = cmd.ExecuteReader();
                GridView1.DataBind();
                con.Close();
            }


        }
    }
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {


        for (int i = 0; i < GridView1.Rows.Count; i++)
        {

            GridView1.Rows[i].Cells[3].Text = Convert.ToString(Convert.ToDecimal(GridView1.Rows[i].Cells[1].Text) * Convert.ToDecimal(GridView1.Rows[i].Cells[2].Text));

        }

    }
}

id  quantity   priceperunit  total

1   5           0.25         1.25

2   10          2.25         22.50

3   15          2.15         32.25

4   20          2.25         45.50

How to multiplication of two column in gridview in Asp.Net C#

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0