How to show grand total in datagridview footer

Atul Rokade

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 < dataGridView1.Rows.Count - 1; 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);

}

7 Replies

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

Mageshwaran R6y ago
Hi,
Please refer the below link, it might helps you
https://www.youtube.com/watch?v=agh2gWojRM8
Puppy Kumari6y ago
See this link--

https://www.youtube.com/watch?v=Erhvmag787M
Vinay Singh10y ago
Hi
Try the below code
publicpartialclassForm1:Form
{
publicForm1()
{
InitializeComponent();
dataGridView1.DataSourceChanged+=newEventHandler(dataGridView1_DataSourceChanged);
}
voiddataGridView1_DataSourceChanged(objectsender,EventArgse)
{
intsum=0;
intsum2=0;
for(inti=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;
}
privatevoidbutton1_Click(objectsender,EventArgse)
{
stringsqlstr="DataSource=.;InitialCatalog=pp1;IntegratedSecurity=True";
using(SqlConnectionconn=newSqlConnection(sqlstr))
{
SqlCommandcmd=newSqlCommand("select*fromfinal",conn);
conn.Open();
SqlDataAdapterad=newSqlDataAdapter(cmd);
DataSetds=newDataSet();
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 Rokade10y ago
thank you for rpl but i want to show these detail in datagridview c#.net(windows application)
Dharmesh Singh10y ago
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
Dharmesh Singh10y ago
AutoGenerateColumns="False" DataKeyNames="ID" CellPadding="4"
ForeColor="#333333" GridLines="None" ShowFooter="True"
onrowdatabound="GridView1_RowDataBound">

Text='<%# Bind("reportDate", "{0:dd MMMM yyyy}") %>'>

Text='<%# Bind("sponsorBonus", "{0:0.00}") %>'>

Text='<%# Bind("pairingBonus", "{0:c}") %>'>

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 Singh10y ago
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