C# 对dataGridView操作

 private DataSet ds = new DataSet();
        private SqlConnection conn = null;
        private SqlDataAdapter da = null;
        private const string DRIVER = "server=.;database=northwind;uid=sa;pwd=sa";
        private const string sql_select = "select * from region";
        // 此方法为将数据库northwind中的region表的数据查询出来并放入DataSet中
        private void Form1_Load(object sender, EventArgs e)
        {
            conn = new SqlConnection(DRIVER);
            da = new SqlDataAdapter(sql_select, conn);
            da.Fill(ds, "table");
            this.dataGridView1.DataSource = ds.Tables["table"].DefaultView;
        }
        private bool BtnInsert() //此方法作用于添加
        {
            da.InsertCommand = conn.CreateCommand();
            da.InsertCommand.CommandText = "insert into region(id,ption) values(@id,@ption)";
            da.InsertCommand.Parameters.Add("@id", SqlDbType.Int, 4, "regionid");
            da.InsertCommand.Parameters.Add("@ption", SqlDbType.VarChar, 10, "regiondescription");
            int count = da.Update(ds);
            bool result = count > 0 ? true : false;
            return result;
        }
        private void button1_Click(object sender, EventArgs e)
        {
            if (this.BtnInsert())//调用此方法
            {
                MessageBox.Show("添加成功!");
            }
            else
            {
                MessageBox.Show("添加失败!");
            }
        }
        private bool BtnDelect() //此方法作用于删除
        {
            SqlParameterpara = new SqlParameter();
            da.DeleteCommand = conn.CreateCommand();
            da.DeleteCommand.CommandText = "delete fromregion where regionid=@id";
            para = da.DeleteCommand.Parameters.Add("@id", SqlDbType.Int, 4, "regionid");
            para.SourceVersion = DataRowVersion.Original;//获取原始值
            ds.Tables["table"].Rows[this.dataGridView1.CurrentRow.Index].Delete();
            int count = da.Update(ds);
            bool result = count > 0 ? true : false;
            return result;
        }
        private void button2_Click(object sender, EventArgs e)
        {
            if (this.BtnDelect())//调用删除方法
            {
                MessageBox.Show("删除成功!");
            }
            else
            {
                MessageBox.Show("删除失败!");
            }
        }
        private bool BtnUpdate() //此方法作用于修改
        {
            SqlParameter para = new SqlParameter();
            da.UpdateCommand = conn.CreateCommand();
            da.UpdateCommand.CommandText = "update region set regionid=@id,regiondescription=@ption where regionid=@oldid";
            da.UpdateCommand.Parameters.Add("@id", SqlDbType.Int, 4, "regionid");
            da.UpdateCommand.Parameters.Add("@ption", SqlDbType.VarChar, 10, "regiondescription");
            para = da.UpdateCommand.Parameters.Add("@oldid", SqlDbType.Int, 4, "regionid");
            para.SourceVersion = DataRowVersion.Original;
            int count = da.Update(ds);
            bool result = count > 0 ? true : false;
            return result;
        }
        private void button3_Click(object sender, EventArgs e)
        {
            if (this.BtnUpdate())//调用修改方法
            {
                MessageBox.Show("修改成功!");
            }
            else
            {
                MessageBox.Show("修改失败!");
            }
        }