calculate total rows of datagrid

Hello @Carlos you can achieve this using two ways

 

first is using  data table

 Float Count;

 Float Total=0;
foreach(DataRow Dr in _Tab.Rows)
{
float.TryParse(Dr["Balance "].ToString(), out Count);
Total+=Count;

} 

GridView1.FooterRow.Cells[SumColumn].Text = Sum.ToString(); 

Here Put Your table name instead of  _Tab 

 

and second is using datagridview

 Float Count;
Float Total=0;

foreach(DataGridViewRow Dr in dataGridView1.Rows)
{
float.TryParse(Dr.Cells[2].ToString(), out Count); 
Total+=Count;

} 

 GridView1.FooterRow.Cells[SumColumn].Text = Sum.ToString();

according my advice   you should be prefer first  method  

Hi,

 

You can try this :

 

int Sum = 0;
int SumColumn = 0;
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
GridViewRow GVRow = e.Row;
if (GVRow.RowType == DataControlRowType.DataRow)
{
TableCell Cell = GVRow.Cells[SumColumn]; // index of cell
try
{
Int32 CellValue = Convert.ToInt32(Cell.Text);
Sum += CellValue;
}
catch
{
// ignore bad data
}
}
}
protected void GridView1_DataBound(object sender, EventArgs e)
{
GridView1.FooterRow.Cells[SumColumn].Text = Sum.ToString();
}

 

For more info check these links :

http://www.codeproject.com/Articles/249429/Frequently-Asked-Questions-Series-1-The-ASP-Net-Gr#heading0016 

http://csharpdotnetfreak.blogspot.com/2009/07/display-total-in-gridview-footer.html 

Hi carlos,

 

After bind the dataGridView. You can use DataSourceChanged event. There you have to apply a loop to add all the balance. Hope this will help.