VC(MFC) ADO ACCESS Ö´ÐÐINSERTÓï¾ä,³ö´í.

ÏÈллÁË,Ö±½Ó´úÂë°É
strSql.Format("insert into hhdz_password(name,areaId,ip,mark,createDate,id,password)\
values('"+ m_Code +"', '"+ m_AreaId +"', '127.0.0.1',\
'"+ m_User_Count +"', #%s#, '"+ tempGetGuid +"', '"+ m_StrResult +"')", dateTime.Format(VAR_DATEVALUEONLY));

Êý¾Ý:
order  ×Ô¶¯±àºÅ
name  Îı¾
areaId  Îı¾
ip Îı¾
mark  Îı¾
createDate ÈÕÆÚ
id  Îı¾
password  Îı¾

Ö´ÐР m_pConnection->Execute((_bstr_t)strSql, NULL, adCmdText); ³ö´í

idÄÇÀï,¼Ó²»¼Ó[],¶¼´í.

---

"insert into hhdz_password(name,areaId,ip,mark,createDate,[id],[password]) values('1234zxcv', '6B7C76D784529A7473921C74794F2368', '127.0.0.1', '1234', #2010-2-8#, 'B4E0CD1E32A54be59C22374D92BCED26', '3fb12509')"

---

ºÃËƵÚÒ»INSERTÊý¾Ý¾ÍOK,È»ºóµÚ¶þ¸öINSERTÊý¾Ý,Ö»ÊÇÔÚÄǸömark¸ÄÁËÊý¾Ý,È»ºó¾Í³ö´í,ÎÒÔÚÇ°ÃæÕâÑùµÄÅжÏ
strSql.Format("select * from hhdz_password where\
[name]='"+ m_User_Jihao +"' and\
[areaId]='"+ m_AreaId +"' and\
[mark]='"+ m_User_Count +"' and\
[createDate]=#%s#", dateTime.Format(VAR_DATEVALUEONLY));
ÒòΪmarkΪÆäÖÐÒ»¸öÅжÏÌõ¼þ,ÈÏΪÊDz»Í¬µÄÊý¾Ý,Ò²ÒªNI