方法一:
try
{
//using (SqlConnection conn1 = new SqlConnection(connectionString))
//{
// conn1.Open();
// using (SqlCommand command = conn1.CreateCommand())
//{
string Temtext = "delete from Student3 where Id=@Id";
SqlParameter paras = new SqlParameter("@Id", textBox1.Text);
int i = SqlHelper.ExecuteNonQuery(Temtext, CommandType.Text, paras);
if (i > 0)
MessageBox.Show("数据已删除");
if (MessageBox.Show("是否继续删除?", "删除对话框", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
textBox1.Text = "";
}
else
{
this.Close();
}
// }
// }
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
}
方法二:
//if (this.dataGridView1.SelectedRows.Count > 0)
//{
// DataGridViewRow row = this.dataGridView1.SelectedRows[0];
// #region 删除数据库中的数据
// string sqlserstr = "Data Source=IDEA-PC;Initial Catalog=BookDB;User ID=sa;Password=abcdef";
// SqlConnection conn = new SqlConnection(sqlserstr);
// conn.Open();
// SqlCommand cmd = new SqlCommand();
// cmd.Connection = conn;
// cmd.CommandText = "delete from Student3 where Id=@id";
// cmd.Parameters.AddWithValue("@id", row.Cells[0].Value.ToString());
// cmd.ExecuteNonQuery();
// cmd.Dispose();
// conn.Close();
// conn.Dispose();
// MessageBox.Show("删除成功");
// //获取当前选中的行,返回值为DataGridViewRow
// this.dataGridView1.Rows.Remove(row);
// #endregion
//}