Sum the values of the datagridview cell columns

In this blog we will know how to 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