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.