C# - WinForm-学员对象删除

删除学员对象示例

后台删除方法

 /// <summary>
        /// 删除学员对象
        /// </summary>
        /// <param name="studentId"></param>
        /// <returns></returns>
        public int DeleteStuent(string studentId)
        {
            string sql = "Delete from Students where StudentId=" + studentId;
            sql = string.Format(sql, studentId);
            try
            {
                return SQLHelper.Update(sql);
            }
            catch (SqlException ex)
            {
                if (ex.Number == 547)
                    throw new Exception("该学员被其他数据表引用不能直接删除！");
                else
                    throw new Exception("删除学员对象发生错误"+ ex.Message);
            }
            catch (Exception ex)
            {
                throw new Exception("删除学员对象发生错误" + ex.Message);
            }

---

前台删除按钮事件方法

 //删除事件
        private void btnDel_Click(object sender, EventArgs e)
        {
            if(this.dgvStudentList.RowCount==0)
            {
                MessageBox.Show("没有删除的信息", "删除提示");
                return;
            }
            if (this.dgvStudentList.CurrentRow == null)
            {
                MessageBox.Show("请选择要删除的信息", "删除提示");
                return;
            }
            DialogResult result = MessageBox.Show("确认删除吗？", "删除提示", MessageBoxButtons.OKCancel,
                MessageBoxIcon.Question);
            if (result == DialogResult.Cancel) return;
            //获取要删除的学号
            string studentId = this.dgvStudentList.CurrentRow.Cells["StudentId"].Value.ToString();
            if(objStudentService.DeleteStuent(studentId)==1)
            {
                MessageBox.Show("删除成功", "删除提示");
                btnQuery_Click(null, null);
            }

        }