string SQLDelString = @"DELETE FROM Teacher WHERE Teacher_No = @Teacher_No AND Department_No = '" + mDepatementNo + "'"; try { mDataConn.DataBaseOpen(); SqlCommand cmd = new SqlCommand(SQLDelString, mDataConn.DataBaseConnectionObject); cmd.Parameters.Add( "@Teacher_No", SqlDbType.Char, 20, "教师编号"); string filt = @"选择 = True"; bool ishavedelinfor = false; foreach (DataRow row in mDataSet.Tables["管理教师基本信息"].Select(filt)) { row.Delete(); ishavedelinfor = true; } if (ishavedelinfor == false) { MessageBox.Show(this, "没有选择删除项!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (MessageBox.Show(this, "是否删除选择项!", "提示信息", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes ) { mSQLDataAda.DeleteCommand = cmd; mSQLDataAda.Update(mDataSet, "管理教师基本信息"); MessageBox.Show(this, "删除成功!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); } finally { mDataConn.DataBaseClose(); }