批量修改DataGridView中的数值数据

 using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace Wage
{
    public partial class frm_PiLiang_Shuju_XiuGai : Form
    {
        DataGridView dgv = new DataGridView();//传入的参数
        double shuju;
        public frm_PiLiang_Shuju_XiuGai()
        {
            InitializeComponent();
        }

        private void button_QuanXuan_Click(object sender, EventArgs e)
        {
            for (int i = 0; i < dgv.Rows.Count; i++)
            {
                dgv.Rows[i].Cells["isSelect"].Value = true;
            }
        }

        private void button_XiuGai_Click(object sender, EventArgs e)
        {
            dgv = this.dataGridView1;
            //检查数据是否有效
            int xiugai_Column = this.comboBox_XuanZe_XiangMu.SelectedIndex;
            if (this.comboBox_XiuGai_FangShi.SelectedIndex == -1)
            {
                MessageBox.Show("请选择修改方式。", "提示 修改方式", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;

            }
            if (this.comboBox_XuanZe_XiangMu.SelectedIndex == -1)
            {
                MessageBox.Show("请选择项目。", "提示 选择项目", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }
            if (String.IsNullOrEmpty(this.textBox_GongZi_ShuJu.Text.Trim()))
            {
                MessageBox.Show("请输入数据。", "提示 工资数据", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }
            try
            {
                double gongzi_Shuju = Convert.ToDouble(this.textBox_GongZi_ShuJu.Text.Trim());
                shuju = gongzi_Shuju;
            }
            catch (Exception ex)
            {
                MessageBox.Show("请在“工资数据”框输入有效的数字。", "提示 工资数据", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }
            for (int i = 0; i < dgv.Rows.Count; i++)
            {
                double oldValue;
                try
                {
                    oldValue = Convert.ToDouble(dgv.Rows[i].Cells[xiugai_Column].Value);
                }
                catch
                {
                    MessageBox.Show("要修改的列不是数字。", "提示 选择项目", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

            }
            //执行修改

            for (int i = 0; i < dgv.Rows.Count; i++)
            {
                if (!Convert.ToBoolean(dgv.Rows[i].Cells["isSelect"].Value))
                {
                    continue;
                }
                double oldValue;
                try
                {
                    oldValue = Convert.ToDouble(dgv.Rows[i].Cells[xiugai_Column].Value);
                }
                catch
                {
                    MessageBox.Show("要修改的列不是数字。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }
                double newValue = 0.0;

                switch (this.comboBox_XiuGai_FangShi.SelectedIndex)
                {
                    case 0: newValue = shuju; break;
                    case 1: newValue = oldValue + shuju; break;
                    case 2: newValue = oldValue - shuju; break;
                    case 3: newValue = oldValue * shuju; break;
                    case 4: newValue = oldValue / shuju; break;
                    default: MessageBox.Show("选择的修改方式不正确。"); return;
                        break;
                }
                dgv.Rows[i].Cells[xiugai_Column].Value = newValue;
            }
            MessageBox.Show("修改完成。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);

        }

        private void button_Close_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void frm_PiLiang_XiuGai_Load(object sender, EventArgs e)
        {
            dgv = this.dataGridView1;
            //修改项目 来源于datatable or datagridview
            for (int i = 0; i < dgv.Columns.Count; i++)
            {
                this.comboBox_XuanZe_XiangMu.Items.Add(dgv.Columns[i].Name.ToString());
            }

 

        }

        private void button_FanXuan_Click(object sender, EventArgs e)
        {
            for (int i = 0; i < dgv.Rows.Count; i++)
            {
                if (Convert.ToBoolean(dgv.Rows[i].Cells["isSelect"].Value))
                {
                    dgv.Rows[i].Cells["isSelect"].Value = false;
                }
                else
                {
                    dgv.Rows[i].Cells["isSelect"].Value = true;
                }

            }
        }
    }
}