DataGridView绑定数据源并实现增删保存

public DataTable DgvBinding(ref OracleDataAdapter adapter, ref OracleCommandBuilder builder, ref DataTable dt, string sql, params OracleParameter[] parameters)
        {
            adapter = new OracleDataAdapter();
            OracleCommand cmd = new OracleCommand();
            cmd.CommandText = sql;
            cmd.Connection = new SQLHelper().DBConn();
            cmd.Parameters.AddRange(parameters);
            adapter.SelectCommand = cmd;
            builder = new OracleCommandBuilder(adapter);
            dt = new DataTable();
            adapter.Fill(dt);
            return dt;
        }

dgvDept.DataSource = new ClassFile.BindingData().DgvBinding(ref adapter, ref builder, ref dtDgvDeptVsClinic, sql);//绑定数据源

 private void btnDel_Click(object sender, EventArgs e)//删除
        {
            foreach (DataGridViewRow dgvRow in dgvDept.SelectedRows)
            {
                dgvDept.Rows.Remove(dgvRow);
            }
        }

<pre name="code" class="csharp">private void btnAdd_Click(object sender, EventArgs e)//增加
        {
            DataRow dr = dtDgv.NewRow();
            dr["DEPT_CODE"] = DeptCode;
            dr["SERIAL_NO"] = (dgv.RowCount + 1).ToString();
            dr["ROOM_CODE"] = (dgv.RowCount + 1000001).ToString().Substring(1);
            dtDgv.Rows.Add(dr);
        }

 private void btnRefresh_Click(object sender, EventArgs e)//刷新
        {
            dtDgv.RejectChanges();
        }

private void btnSave_Click(object sender, EventArgs e)//保存
        {
            foreach (DataGridViewRow dgvRow in dgvDept.Rows)
            {
                if (string.IsNullOrEmpty(dgvDept.Rows[dgvRow.Index].Cells["DEPT_CODE"].Value.ToString()))
                {
                    MessageBox.Show("第" + (dgvRow.Index + 1).ToString() + "行的科室不能为空!", "提示");
                    return;
                }
            }
            adapter.Update(dtDgv);
        }