update更新数据库 求指教
使用update将数据库内 表user 满足字段BOSASN为m_edit1的Sensitvity字段更新为1,下面是我写的代码连接字串没问题,大家帮看下是哪里出了问题。感激不尽~
CoInitialize(NULL);
_ConnectionPtr pConn(_uuidof(Connection));
_RecordsetPtr pRst(_uuidof(Recordset));
pConn->ConnectionString="Database=XXXX;Provider=XXXX;Password=abcd;Persist Security Info=True;User ID=sa;Data Source=XXX.XX.XX.X,1433";
pConn->Open("","","",adConnectUnspecified);
UpdateData(true);
CString strSql;
strSql.Format(("UPDATE user SET Sensitvity='1' WHERE BOSASN='s%'"),m_edit1);