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 = 数字
慕少森