C# How to display total in database gridview

Rajveer Singh

11y1.2k.NET

I have created a database.. i have created a column for "Donations"

in my web form i would like to display the total amount of donations.

how can i do that? and my datatype for "Donation" column is INT

Example: First row is 2000, Second row is 3000

So i want to display the total which is 5000. How can i do that?

17 Replies

Know the answer? Post it — somebody with the same question will find it here.

Raja T11y ago
Accepted answer
Hi Rajveer, Try this code

Gridview code change like

HeaderStyle-ForeColor="White" HeaderStyle-Font-Bold="true"

runat="server" ShowFooter="true" AllowPaging="true" PageSize="5" AutoGenerateColumns="false"

OnRowDataBound="gvPurchaseOrderDetail_RowDataBound">

In Code behinde cod like

private void loadGrid()

{

string sqlQry = "select * from tbl_test1";

SqlCommand cmd = new SqlCommand(sqlQry, con);

cmd.CommandType = CommandType.Text;

SqlDataAdapter sda = new SqlDataAdapter(cmd);

DataTable dt = new DataTable();

DataSet ds = new DataSet();

sda.Fill(ds);

gvPurchaseOrderDetail.DataSource = ds;

gvPurchaseOrderDetail.DataBind();

}

protected void gvPurchaseOrderDetail_RowDataBound(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowType == DataControlRowType.DataRow)

{

Label lblPrice = (Label)e.Row.FindControl("lblPrice");

decimal price = Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "donations"));

lblPrice.Text = price.ToString();

total += price;

}

if (e.Row.RowType == DataControlRowType.Footer)

{

Label lblTotal = (Label)e.Row.FindControl("lblTotal");

lblTotal.Text = total.ToString();

}
}

protected void Button1_Click(object sender, EventArgs e)
{
SqlCommand cmd = new SqlCommand("Insert into customer(Id, Name, Email, Address, Number, Date, Donation) Values (@Id, @Name, @Email, @Address, @Number, @Date, @Donation)", con);
cmd.Parameters.AddWithValue("@Id", tb1.Text);
cmd.Parameters.AddWithValue("@Name", tb2.Text);
cmd.Parameters.AddWithValue("@Email", tb3.Text);
cmd.Parameters.AddWithValue("@Address", tb4.Text);
cmd.Parameters.AddWithValue("@Number", tb5.Text);
cmd.Parameters.AddWithValue("@Date", Calendar1.SelectedDate.ToShortDateString());
cmd.Parameters.AddWithValue("@Donation", tb7.Text);
cmd.ExecuteNonQuery();
con.Close();
loadGrid();
}
+1
Rajveer Singh11y ago
Hi Raja, please check my new thread. i hope u will help me thanks :)
0
Raja T11y ago
Hi Rajveer, Thanks for appreation :). ALL THE BEST.
0
Rajveer Singh11y ago
yes it work thank u so much!!! you are awesome!!!
0
Upendra Pratap Shahi11y ago
Hello Rajveer Singh,
have you tried my code.
0
Raja T11y ago
Hi, Please declare variable in global/public accessmodifier "decimal total = 0;"
0
Rajveer Singh11y ago
Hello im having error: Error: The name 'total' does not exist in the current context
0
Raja T11y ago
Hi, If you useful my answer kindly accept the answer.
0
Rajveer Singh11y ago
Customer.aspx

CUSTOMER DONATIONS

.cs

protected void Button1_Click(object sender, EventArgs e)
{
SqlCommand cmd = new SqlCommand("Insert into customer(Id, Name, Email, Address, Number, Date, Donation) Values (@Id, @Name, @Email, @Address, @Number, @Date, @Donation)", con);
cmd.Parameters.AddWithValue("@Id", tb1.Text);
cmd.Parameters.AddWithValue("@Name", tb2.Text);
cmd.Parameters.AddWithValue("@Email", tb3.Text);
cmd.Parameters.AddWithValue("@Address", tb4.Text);
cmd.Parameters.AddWithValue("@Number", tb5.Text);
cmd.Parameters.AddWithValue("@Date", Calendar1.SelectedDate.ToShortDateString());
cmd.Parameters.AddWithValue("@Donation", tb7.Text);
cmd.ExecuteNonQuery();
con.Close();
GridView1.DataBind();
GridView2.DataBind();
Label8.Visible = true;
Label8.Text = "NEW CUSTOMER ADDED";

0
Raja T11y ago
Please checkout url http://weblogs.asp.net/jhallal/displaying-summary-information-sum-or-total-in-the-gridview-s-footer
0
Raja T11y ago
yes share your code here...
0
Rajveer Singh11y ago
hi i already have the GridView in my project so should i add a Label? do you need to see the code?
0
Raja T11y ago
Hi Rajveer, try this query "SELECT SUM(donations) as Sum FROM tbl_test1"
0
Upendra Pratap Shahi11y ago
Read the article carefully and download the code and debug in your system and you will get your answer.
-1
Rajveer Singh11y ago
i dont understand can u please explain further thanks
0
Upendra Pratap Shahi11y ago
Hello,

Go through my article-

http://www.c-sharpcorner.com/UploadFile/77a82c/add-row-total-in-gridview-footer-in-Asp-Net/

kindly accept the answer.
0
Suraj Sahoo11y ago
Hello Rajveer,
You can fetch the Sum of Donations column from the SQL query itself like:

SELECT SUM(Donations) FROM TABLE_NAME
--IF ANY WHERE COND
GROUP BY Donations

I hope this helps
Thanks
Accept if helps anyway
0

C# How to display total in database gridview

CUSTOMER DONATIONS