VC ado ¶¯Ì¬´´½¨ACCESS ±í£¬Ôõô×ö£¿

C/C++ code:
//´ò¿ª¼Ç¼¼¯
try
{
m_pLampOnSet->Open("SELECT * from LampOnTable", // ²éѯMapInfo±íÖÐËùÓÐ×Ö¶Î
theApp.m_pConnection.GetInterfacePtr(), // »ñÈ¡¿â½Ó¿âµÄIDispatchÖ¸Õë
adOpenDynamic,
adLockOptimistic,
adCmdText);
}
catch(_com_error *e)
{
AfxMessageBox(e->ErrorMessage());
}


´ò¿ªÊÇÉÏÃæµÄ²Ù×÷£¬ 
´´½¨ÊDz»Êǽ«SELECT * from LampOnTable" »»³É ´´½¨µÄSQLÓï¾ä ¾Í¿ÉÒÔÁË £¿


лл£¡             

---

_variant_t RecordsAffected;
¡¡¡¡m_pConnection->Execute("CREATE TABLE new(ID INTEGER,username TEXT,old INTEGER)",&RecordsAffected,adCmdText);

---

// lsµÄ¿ÉÒÔ

---

¿ÉÒÔÖ±½ÓÓÃExecute·½·¨  ¶øÇÒÍƼöÓÃÕâ¸ö 

---

C/C++ code:

_variant_t RecordsAffected;
m_pConnection.CreateInstance(__uuidof(Connection));
m_pConnection->Execute("CREATE TABLE Test(A TEXT,B EXT)",&RecordsAffected,adCmdText);
//Õâ¸öÖ±½ÓÔÚExecute±¨´í£¬²»ÖªµÀʲôԭÒò




C/C++ code

---

Code highlighting p