VC+ado+sql´´½¨±í

¸÷λ´ó¼ÒºÃ
VC+ado+sql´´½¨±í

ÎÒÊý¾Ý¿âÀïÓÉÒ»ÕÅTABLE±í£¬ÏÖÔÚÎÒÒªÒ»ÕÅTABLE1±í¡££¨×¢£ºÎÒËù½¨µÄTABLE1±íͨ¹ý¶Ô»°¿òÉϵÄÒ»±à¼­¿òÊäÈ룬µã»÷°´Å¥ºóÒª½¨Á¢TABLE1±í£¬²¢ÇÒTABLE1±íÖеÄËùÓÐ×Ö¶ÎÊÇ´ÓTABLE±íÖжÁ³ö£¨³ýTABLE±íÖеĵÚÒ»¸öID×ֶΣ©Ò²¾ÍÊÇ˵TABLE1ÖеÄ×ֶκÍTABLEÖеÄÒ»Ñù³ýID×Ö¶ÎÍ⣩£¬Õâ¸öÎÊÌâÔõô½â¾öѽ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿

лл

---

Æ´´ÕSQLÓï¾ä£¬²»ÄÑ°É

---

×µÄ°ì·¨£ºÒ»¸öÑ­»·£¬Ò»ÌõÌõ²é³öÀ´Ò»ÌõÌõд½øÈ¥

---

1¡¢¶ÁÈ¡Table±íÖÐËùÓÐ×ֶΣ¬°üÀ¨×Ö¶ÎÊôÐÔ
2¡¢´Ó¶Ô»°¿òÖжÁÈ¡±íÃû
3¡¢¸ù¾Ý±íÃûºÍ¶ÁÈ¡µÄ×Ö¶ÎÊôÐÔ´´½¨ÐÂ±í¡£

´´½¨±íµÄ´úÂë¾Í²»ÌùÁË£¬ÒÔÏ´úÂë»ñÈ¡Êý¾Ý¿â×Ö¶ÎÃû£º
C/C++ code:

ADOX::_CatalogPtr pCatalog;
pCatalog.CreateInstance(__uuidof(ADOX::Catalog));

VARIANT var;
var.vt = VT_DISPATCH;
var.pdispVal = m_pConnection;
pCatalog->put_ActiveConnection(var); // ÉèÖÃÁ¬½Ó

ADOX::TablesPtr pTables = pCatalog->Tables;

int iCount = pTables->Count;
for(long i=0;i<iCount;i++) // ʹÓÃlong£¬¶ø·Çint
{
ADOX::_TablePtr pTable = pTables->GetItem(i);

CString strTableName = (TCHAR*)pTable->Name;

m_DatabaseInformation.AddTableName(strTableName);

CTableInformation* pTableInfo = new CTableInformation();
pTableInfo->SetName(strTableName);