這是我的代碼，否則條件不執行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");}請幫助…………
3 回答
胡說叔叔
TA貢獻1804條經驗 獲得超8個贊
我認為計數應該是查詢中的 RowsAffected，而不是網格中的行數。
count = cmd.ExecuteNonQuery();
//count = Convert.ToInt32(dt.Rows.Count.ToString());
- 3 回答
- 0 關注
- 164 瀏覽
添加回答
舉報
0/150
提交
取消