Question

C#删除sql数据库中的数据代码

private void 删除ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (lvPatients.SelectedItems.Count <= 0)
{
MessageBox.Show("请选中删除项");
return;
}
string id = textBoxid.Text.Trim();
string strsql = "delete form gongzi where ID=" + id + "";
SqlCommand com = new SqlCommand(strsql, con);
con.Open();
int count = com.ExecuteNonQuery();
if (count > 0)
{
lvPatients.Items.RemoveAt(selectIndex);
MessageBox.Show("删除成功！");
}
else
{
MessageBox.Show("删除失败！");
}
}

Answer 1

delete from 写错了吧

Answer 2

delete form gongzi where ID ===>delete from gongzi where ID

Answer 3

问题没有描述啊