Sum the values of the datagridview cell columns

In this blog we will know how to sum the values of the datagridview cell columns.

 

 

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_in_datagridview

{

    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();

        }

 

        private void btn_sum_Click(object sender, EventArgs e)

        {

            int sum = 0;

            for (int i = 0; i < dataGridView1.Rows.Count; ++i)

            {

                sum += Convert.ToInt32(dataGridView1.Rows[i].Cells[1].Value);

            }

            label1.Text = "Total sum is:"+sum.ToString();

 

 

        }

    }

}

 

 

 

Thanks for reading