Displaying Sum of two values in Gridview wiout saing in Data

Home
»
.NET General
»
Displaying Sum of two values in Gridview wiout saing in Data

AuthorQuestion

Shakti Singh

Displaying Sum of two values in Gridview wiout saing in Data
Posted on: 05 Feb 2013

Hey Friends...

i want a simple example to display a sum of two values in database.

in database i have
id, one and two as row

in default.aspx
I have 2 text box
and one submit button

on clicking to submit button.. values of both the two text box got saved in database
and i can display them on gridview.. by using databind.

now i want that there should be a 3rd column in Gridview which display the total of two numbers.. (1+1 = 3) i.e 3 should be displayed but it's values (3) should not be saved in database.
every time when i run... it display the total of all numbers which are saved in database

example.

one    two        sum
1         1    2

2 2            4

2         5            7

etc.

plz help me as i'm new in asp.

Reply Quick Reply Report a Spam

Our Recommended Solutions

[ + ]

AuthorReply

Jignesh Trivedi

Re: Displaying Sum of two values in Gridview wiout saing in Data
Posted on: 05 Feb 2013

hi,

you may use RowDataBound even of Grid view.
this event is fired when your datasource is bind with grid view. also this event is available for each of row.

try...

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
        if(e.Row.RowType == DataControlRowType.DataRow)
        {
            e.Row.Cells[2].Text = Convert.ToInt32(e.Row.Cells[0].Text) + Convert.ToInt32(e.Row.Cells[1].Text);
        }
}

replace your original column id with this example

hope this will help you.

Reply Quick Reply

Satyapriya Nayak

Re: Displaying Sum of two values in Gridview wiout saing in Data
Posted on: 05 Feb 2013

sum.rar <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Sum._Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>

</div>
<asp:TextBox ID="txtOne" runat="server"></asp:TextBox>
<p>
<asp:TextBox ID="txtTwo" runat="server"></asp:TextBox>
</p>
<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Button" />
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
</form>
</body>
</html>

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace Sum
{
    public partial class _Default : System.Web.UI.Page
    {
        string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        SqlCommand com;
        SqlDataAdapter sqlda;
        DataSet ds;
        string str;

        protected void Page_Load(object sender, EventArgs e)
        {
            bindgrid();
        }
        private void bindgrid()
        {
            SqlConnection con = new SqlConnection(connStr);
            con.Open();
            str = "select *,(one + two)as 'Sum' from test";
            com = new SqlCommand(str, con);
            sqlda = new SqlDataAdapter(com);
            ds = new DataSet();
            sqlda.Fill(ds, "test");
            GridView1.DataMember = "test";
            GridView1.DataSource = ds;
            GridView1.DataBind();
            con.Close();
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(connStr);
            com = new SqlCommand();
            com.Connection = con;
            com.CommandType = CommandType.Text;
            com.CommandText = "insert into test values(@one,@two)";
            com.Parameters.Clear();
            com.Parameters.AddWithValue("@one", txtOne.Text);
            com.Parameters.AddWithValue("@two", txtTwo.Text);
            if (con.State == ConnectionState.Closed)
                con.Open();
            com.ExecuteNonQuery();
            con.Close();
            bindgrid();
        }
    }
}

Thanks
If this post helps you mark it as answer

If this post helps you mark it as answer
Thanks

Reply Quick Reply

Satyapriya Nayak

Re: Displaying Sum of two values in Gridview wiout saing in Data
Posted on: 06 Feb 2013

If this post helps you mark it as answer

Thanks

If this post helps you mark it as answer
Thanks

Reply Quick Reply

SEARCH ANSWERS

Our recommended forum posts

HOT QUESTIONS

In Focus

Our Recommended Solutions

SEARCH ANSWERS