string connStr = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source = System.accdb;";OleDbConnection connect1 = new OleDbConnection(connStr);string strSQL1;strSQL1 = "update Point_card set [Status] = 'suspend' where Card_id = 'Convert.ToInt32(txtSuspend.Text) ';";OleDbCommand sql2 = new OleDbCommand(strSQL1);sql2.Connection = connect1;connect1.Open();sql2.ExecuteNonQuery();connect1.Close();MessageBox.Show("Point card suspend successful");DATABASE: status = 文字Card_id = 数字
1 回答
慕少森
TA贡献2019条经验 获得超9个赞
strSQL1 = "update Point_card set [Status] = 'suspend' where Card_id =" + txtSuspend.Text; |
- 1 回答
- 0 关注
- 120 浏览
添加回答
举报
0/150
提交
取消