Question

执行删除 cmd.ExecuteNonQuery(); '*' 附近有语法错误。

private void btDel_Click(object sender, EventArgs e)
{
if (dataGrid1.CurrentRowIndex >= 0 && dataGrid1.DataSource != null && dataGrid1[dataGrid1.CurrentCell] != null)
{
conn.Open();
string sql = "delete * from person where PID='" + ds.Tables[0].Rows[dataGrid1.CurrentCell.RowNumber][0].ToString().Trim() + "'";
SqlCommand cmd = new SqlCommand(sql, conn);

cmd.ExecuteNonQuery(); //'*' 附近有语法错误。
MessageBox.Show("删除借阅者'" + ds.Tables[0].Rows[dataGrid1.CurrentCell.RowNumber][1].ToString().Trim() + "'成功", "提示");

}
else
return;
}

Answer 1

delete from person 不需要* delete就是源顷删掉一整条记录，你还唯裂困指念要指定字段不成