calculate total rows of datagrid

Question

i have table with following rows student_id, name, Balance now i want to calculate total balance at the bottom of datagridview,any a idea on how to do it

Pankaj Kumar Choudhary · Answer

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

Manoj Bhoir · Answer

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

Alok Uniyal · Answer

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. void dataGridViewStudent_DataSourceChanged(object sender, EventArgs e) { int sum = 0; for (int i = 0; i { if(dataGridViewStudent[2, i].Value != DBNull.Value) sum += (int)dataGridViewStudent[2, i].Value; } dataGridViewStudent[2, dataGridViewStudent.Rows.Count - 1].Value = sum; }

calculate total rows of datagrid

Answers (3)