C# How to display total in database gridview

Question

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?

Raja T · 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() ; }

Rajveer Singh · Answer

Hi Raja, please check my new thread. i hope u will help me thanks :)

Raja T · Answer

Hi Rajveer, Thanks for appreation :). ALL THE BEST.

Rajveer Singh · Answer

yes it work thank u so much!!! you are awesome!!!

Upendra Pratap Shahi · Answer

Hello Rajveer Singh, have you tried my code.

Raja T · Answer

Hi, Please declare variable in global/public accessmodifier "decimal total = 0;"

Rajveer Singh · Answer

Hello im having error: Error: The name 'total' does not exist in the current context

Raja T · Answer

Hi, If you useful my answer kindly accept the answer .

Rajveer Singh · Answer

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";

Raja T · Answer

Please checkout url http://weblogs.asp.net/jhallal/displaying-summary-information-sum-or-total-in-the-gridview-s-footer

Raja T · Answer

yes share your code here...

Rajveer Singh · Answer

hi i already have the GridView in my project so should i add a Label? do you need to see the code?

Raja T · Answer

Hi Rajveer, try this query "SELECT SUM(donations) as Sum FROM tbl_test1"

Rajveer Singh · Answer

i dont understand can u please explain further thanks

Upendra Pratap Shahi · Answer

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 .

Suraj Sahoo · Answer

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

Upendra Pratap Shahi · Answer

Read the article carefully and download the code and debug in your system and you will get your answer.

C# How to display total in database gridview

Answers (17)