Display Row Total and Grand Total in DataGridView in Windows Application

Hi ajitn4u,

Please refer below sample.

HTML

Code

C#

public partial class Form1 : Form
{
    public Form1()
    {
        InitializeComponent();
        this.BindDataGrid();
    }

    private void BindDataGrid()
    {
        DataTable dt = new DataTable();
        dt.Columns.AddRange(new DataColumn[] { new DataColumn("column1", typeof(string)),
                        new DataColumn("column2", typeof(int)),
                        new DataColumn("column3",typeof(int)),
                        new DataColumn("column4",typeof(int)),
                        new DataColumn("Total",typeof(int))});
        dt.Rows.Add("A", 1, 3, 4);
        dt.Rows.Add("B", 5, 4, 6);

        foreach (DataRow dr in dt.Rows)
        {
            dr["Total"] = Convert.ToInt16(dr["column2"]) + Convert.ToInt16(dr["column3"]) + Convert.ToInt16(dr["column4"]);
        }
        dt.Rows.Add(null, null, null, null);
        dataGridView1.DataSource = dt;
        dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[0].Value = "Total";

        for (int i = 1; i < dataGridView1.Columns.Count; i++)
        {
            int total = 0;
            for (int j = 0; j < dataGridView1.Rows.Count - 1; j++)
            {
                total += Convert.ToInt32(dataGridView1.Rows[j].Cells[i].Value);
            }
            dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[i].Value = total;
        }
    }
}

Screenshot