How to display the sum of values in the cells of last column in datagridview.

Question

Hi I have a grid with 2 columns 'Name' and 'Value'. When the grid is loaded the sum of values in column 'Value' is calculated and shown in a separate label control. But i want the grid itself to generate a textbox/label to hold the sum in the last row when it is loaded. plz help. A sample image is shown below...

Satyapriya Nayak · Answer

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace Sum_datagridview_cell_row_footer { public partial class Form1 : Form { string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings[dsn]; OleDbCommand com; OleDbDataAdapter oledbda; DataSet ds; string str; public Form1() { InitializeComponent(); } private void Form1_Load(object sender EventArgs e) { bindgrid(); } private void bindgrid() { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = select * from product; com = new OleDbCommand(str con); oledbda = new OleDbDataAdapter(com); ds = new DataSet(); oledbda.Fill(ds product); dataGridView1.DataMember = product; dataGridView1.DataSource = ds; con.Close(); dataGridView1[0 dataGridView1.Rows.Count - 1].Value = Total Sum; dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[0].Style.BackColor = Color.Yellow; dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[1].Style.ForeColor = Color.Red; } private void dataGridView1_DataSourceChanged(object sender EventArgs e) { int sum = 0; for (int i = 0; i { if (dataGridView1[1 i].Value != DBNull.Value) sum += (int)dataGridView1[1 i].Value; } dataGridView1[1 dataGridView1.Rows.Count - 1].Value = sum; } } }