110,528
社区成员
发帖
与我相关
我的任务
分享
string CString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Documents and Settings\sunyi\Desktop\v1.0.0.9\PreOpeningAuditClient\bin\Debug\IHG_WindowsApp.mdb";
OleDbConnection connect = new OleDbConnection(CString);
string sql="update tbl_pre_auditdept set qty_to_inspect=qty_to_inspect-1 where audit_id="+AuditID+" and dept_id="+DeptID+" and dept_src='"+DeptSrc+"'";
OleDbCommand cmd1 = new OleDbCommand(sql, connect);
connection.Open();
cmd1.ExecuteNonQuery();
connection.Close();