即使在表中可用，也无法删除记录，[除else条件外，所有条件都运行良好]

Question

这是我的代码，否则条件不执行SqlCommand cmd = new SqlCommand(@"DELETE FROM Demo_Table WHERE (ID = '"+textBox1.Text+"')",con);cmd.ExecuteNonQuery();DataTable dt = new DataTable();SqlDataAdapter sda = new SqlDataAdapter(cmd);sda.Fill(dt);count = Convert.ToInt32(dt.Rows.Count.ToString());if ((textBox1.Text == string.Empty) && (textBox2.Text == string.Empty)){    MessageBox.Show("Provide ID and PASSWORD");    textBox1.Clear();    textBox2.Clear();    textBox1.Focus();}else if (textBox1.Text == string.Empty){    MessageBox.Show("select ID to delete record");    textBox2.Clear();    textBox1.Focus();}else if (count == 0){    MessageBox.Show("wrong ID");}else{    MessageBox.Show("Record Deleted");}请帮助…………

Answer 1

我认为计数应该是查询中的 RowsAffected，而不是网格中的行数。

count = cmd.ExecuteNonQuery();

//count = Convert.ToInt32(dt.Rows.Count.ToString());