How to show grand total in datagridview footer

Question

Hi all I want to show grand total in datagridview footer but here im not using any database connection i want to show grandtotal without using any database connection for this i wrote code but its not working Note : im not using any database connection i want to show this total without any database connection Two Coloumn total : private void dataGridView1_CellEndEdit_1(object sender DataGridViewCellEventArgs e) { double cell1 = 0; double cell2 = 0; if (e.ColumnIndex == 0 || e.ColumnIndex == 2) { if (!object.ReferenceEquals(dataGridView1.CurrentRow.Cells[0].Value DBNull.Value)) { cell1 = Convert.ToSingle(dataGridView1.CurrentRow.Cells[0].Value); } if (!object.ReferenceEquals(dataGridView1.CurrentRow.Cells[2].Value DBNull.Value)) { cell2 = Convert.ToSingle(dataGridView1.CurrentRow.Cells[2].Value); } if (cell1.ToString() !=  && cell2.ToString() != ) { dataGridView1.CurrentRow.Cells[6].Value = cell1 * cell2; } } } GrandTotal code :(this code is not working) private void dataGridView1_DataSourceChanged_1(object sender EventArgs e) { double Total = 0; for (int i = 0; i { Total += Convert.ToDouble(dataGridView1.Rows[i].Cells[Rupees].Value); } dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[Rupees].Value = Total; lblsum.Text = Convert.ToString(Total); }

Dharmesh Singh · Answer

AutoGenerateColumns=False DataKeyNames=ID CellPadding=4 ForeColor=#333333 GridLines=None ShowFooter=True onrowdatabound=GridView1_RowDataBound> '> Text=' '> '> Text=' '> '> Text=' '> '> '> '> '> '> '> And Code Behind decimal sumFooterValue = 0; protected void GridView1_RowDataBound(object sender GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { string sponsorBonus = ((Label)e.Row.FindControl(Label2)).Text; string pairingBonus = ((Label)e.Row.FindControl(Label3)).Text; string staticBonus = ((Label)e.Row.FindControl(Label4)).Text; string leftBonus = ((Label)e.Row.FindControl(Label5)).Text; string rightBonus = ((Label)e.Row.FindControl(Label6)).Text; decimal totalvalue = Convert.ToDecimal(sponsorBonus) + Convert.ToDecimal(pairingBonus) + Convert.ToDecimal(staticBonus) + Convert.ToDecimal(leftBonus) + Convert.ToDecimal(rightBonus); e.Row.Cells[6].Text = totalvalue.ToString(); sumFooterValue += totalvalue } if (e.Row.RowType == DataControlRowType.Footer) { Label lbl = (Label)e.Row.FindControl(lblTotal); lbl.Text = sumFooterValue.ToString(); } }

Vinay Singh · Answer

Hi Try the below code public partial class Form1:Form { public Form1() { InitializeComponent(); dataGridView1.DataSourceChanged+= new EventHandler(dataGridView1_DataSourceChanged); } void dataGridView1_DataSourceChanged( object senderEventArgse) { int sum=0; int sum2=0; for ( int i=0;i { if (dataGridView1[ Debit i].Value!=DBNull.Value) { sum+=( int )dataGridView1[ Debit i].Value; } if (dataGridView1[ Credit i].Value!=DBNull.Value) { sum2+=( int )dataGridView1[ Credit i].Value; } } dataGridView1[ Debit dataGridView1.Rows.Count-1].Value=sum; dataGridView1[ Credit dataGridView1.Rows.Count-1].Value=sum2; } private void button1_Click( object senderEventArgse) { string sqlstr= DataSource=.;InitialCatalog=pp1;IntegratedSecurity=True ; using (SqlConnectionconn= new SqlConnection(sqlstr)) { SqlCommandcmd= new SqlCommand( select*fromfinal conn); conn.Open(); SqlDataAdapterad= new SqlDataAdapter(cmd); DataSetds= new DataSet(); ad.Fill(ds); dataGridView1.AllowUserToAddRows= true ; dataGridView1.DataSource=ds.Tables[0]; } } } Try the below link http://www.codeproject.com/Articles/768632/How-to-fake-freeze-last-row-in-datagridview https://social.msdn.microsoft.com/Forums/vstudio/en-US/3e7b3de9-fd19-40a6-8865-a4aee160011e/how-to-display-sum-total-in-the-footer-of-the-datagridview?forum=csharpgeneral http://stackoverflow.com/questions/13056678/datagridview-column-footer-c-net-winforms http://www.dotnetspider.com/forum/338629-How-to-add-Footer-for-datagridview-in-C-Net-windows-application.aspx

Atul Rokade · Answer

thank you for rpl but i want to show these detail in datagridview c#.net(windows application)

Dharmesh Singh · Answer

And You can Also see following Link. http://www.aspsnippets.com/Articles/Display-sum-of-Columns-total-in-GridView-Footer-in-ASPNet-using-C-and-VBNet.aspx

Vinay Singh · Answer

Hi Please check the output http://codedisplay.com/show-grand-total-running-total-sub-total-in-asp-net-gridview-footer-c-vb-net/ http://www.asp.net/web-forms/overview/data-access/custom-formatting/displaying-summary-information-in-the-gridview-s-footer-vb