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 = 數(shù)字
如下,為什么一直說(shuō)我的Data Type unmatch?
達(dá)令說(shuō)
2022-05-20 16:15:24