private void button3_Click(object sender, EventArgs e)
{
try
{
string id = dataGridView1.SelectedRows[0].Cells[0].Value.ToString(); // 获取书号
DialogResult dr = MessageBox.Show("确认删除?","信息提示",MessageBoxButtons.OKCancel,MessageBoxIcon.Question);
if (dr==DialogResult.OK)
{
string sql = $"delete from t_book where id={id}";
Dao dao = new Dao();
if (dao.Execute(sql) > 0)
{
MessageBox.Show("删除成功");
Table(); //重新获取数据
}
else
{
MessageBox.Show("删除失败");
}
dao.DaoClose();
}
}
catch
{
MessageBox.Show("请先在表格选中要删除的图书记录","信息提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}