Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÓÃADO²éѯACCESSÊý¾Ý¿â£¬½á¹ûÏÔʾÔÚlistCtrl

ÓÃADO²éѯACCESSÊý¾Ý¿â£¬½á¹ûÏÔʾÔÚlistCtrl¡«¡«¡«Çë¸ßÊÖ°ï°ï棬²»Ê¢¸Ð¼¤¡«¡«¡«
ÕÒ¸öÏֳɵÄÊý¾Ý¿â¶ÁдÀà¾Í¿ÉÒÔÁË¡£
¶ÁÈ¡Êý¾Ýºó£¬¿´Ò»ÏÂlistctrlµÄʹÓ÷½·¨£¬×Ô¼ºÐ´¡£

http://download.csdn.net/source/1070271
Àý×Ó£¬×Ô¼ºÏÂÔØµÃÁË£¡¼òµ¥Ò×ѧ£¡

²¿·Ö´úÂëÈçÏ£º
C/C++ code:

CListCtrl *pList = (CListCtrl*)GetDlgItem(ID_List);
pList->InsertColumn(0, "ID", LVCFMT_LEFT, 100, -1);
pList->InsertColumn(1, "·ÖÀà", LVCFMT_LEFT, 100, -1);
pList->InsertColumn(2, "½ð¶î", LVCFMT_LEFT, 100, -1);
pList->InsertColumn(3, "˵Ã÷", LVCFMT_LEFT, 100, -1);
pList->InsertColumn(4, "ÈÕÆÚ", LVCFMT_LEFT, 100, -1);

void CDailyAccountDlg::OnQuery()
{
bool flag = true;
CoInitialize(NULL);

_ConnectionPtr pCon(__uuidof(Connection));
_RecordsetPtr pRst(__uuidof(Recordset));


try
{
pCon->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=dailyAccount.mdb", "", "", adConnectUnspecified);
try
{
pRst->Open("select * from daily", _variant_t((IDispatch*)pCon), adOpenDynamic, adLockUnspecified, adCmdText);
while(!pRst->adoEOF)
{
ÎÊÌâËùÔÚ£¬²»»á¸³Öµ£¡
}
}
catch(_com_err


Ïà¹ØÎÊ´ð£º

asp¸úAccessÊý¾ÝÁ¬½ÓÎÊÌâ¡£

IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC)

'===========================================================================
SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû
S ......

Access²éÕÒÖØ¸´ÎÊÌâ

ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏ 
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡± 
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......

ÇóACCESSÊý¾Ý¿â

      ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿
  ¸øÐ¡µÜÒ»¸ö£¡
°²×°OFFICEʱѡÔñ°²×°ACCESS

°²×°OFFICEʱѡÔñ°²×°ACCESS

°²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË

officeÍêÕ ......

ÈçºÎ´ÓACCESSÊý¾Ý¿âÖÐÒ»´Î²éѯ¶à¸ö±í²¢¼ÓÈëÊý¾Ý¼¯?

ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......

MFCÁ¬½ÓACCESS ³ö´í

Âé·³¸÷λ°ïæ¿´¿´°¡
´úÂëÈçÏ£º
CoInitialize(NULL);
  _ConnectionPtr pConn(__uuidof(Connection)); 
_RecordsetPtr pRst(__uuidof(Recordset));
pConn->ConnectionString="Provider ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ