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

来源：互联网发布：单片机相关文献编辑：程序博客网时间：2024/05/21 05:56

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

0 0