在使用CString 向数据库中插入单引号,双引号时,需要先调用Replace 函数,将单引号,双引号用","代替。
CString strSQL;
int nID = 1;
CString strText = "This's desk!";
strText.Replace(",","","");
strSQL.Format(“Insert into database(ID,Text) values(%d, %s)”,nID, strText);
CDatabase db;
CString strConnect = "DNS=list.mdb";
BOOL bOpen = db.Open(strConnect);
db.ExecuteSQL(strSQL);
db.Close();