VCÖÐ odbc·ÃÎÊaccessÄÚ´æÔö³¤
vcÖÐÓÃodbcµÄ·½·¨·ÃÎÊaccessÊý¾Ý¿â£¬Óõ½ÁËcdatabaseÀàºÍcrecordsetÀà¡£Êý¾ÝÔ´ÔÚ´°¿Ú³õʼ»¯µÄʱºò±»´ò¿ªg_datasource.Open("data",FALSE,FALSE); µã»÷Ò»¸ö°´Å¥Æô¶¯Ò»¸ö¶¨Ê±Æ÷£¬ÔÚ¶¨Ê±Æ÷ÄÚÍê³ÉÒÔϲÙ×÷£¬¶¨Ê±Æ÷¼ä¸ô2s¡£
if(nIDEvent==1)
{
cserverrecord serverrecord(&g_datasource);
str.Format("select * from ·þÎñÆ÷¹ÜÀí where ·þÎñÆ÷±àºÅ=%d",i);
serverrecord.Open(CRecordset::snapshot,str);
strtwo=serverrecord.m_column2;
serverrecord.Close();
GetDlgItem(IDC_STATICone)->SetWindowText(strtwo);
i++;
if (i>5)
{
i=1;
}
}
m_column2cserverrecordÊǼ̳ÐÓÚcrecordsetµÄÒ»¸öÀ࣬Õâ¶ÎÓï¾äµÄ×÷ÓþÍÊDzéÃûΪ·þÎñÆ÷¹ÜÀíµÄ±í£¬°Ñ·þÎñÆ÷±àºÅСÓÚ5µÄ¼Ç¼µÄm_column2ÖµÔÚIDC_STATIConeÏÔʾ³öÀ´£¬Êý¾ÝÔ´ÔÚ³ÌÐòÍ˳öʱ¹Ø±Õ¡£ÎÊÌâʱÕâ¶Î³ÌÐòÅÜ4Сʱ³ÌÐòÄÚ´æÔö³¤176k£¬Çë½Ì¸ßÊÖÄÄÀïÓÐÎÊÌâ¡£
4¸öСʱ²Å 176K£¬ÄǾͷÅÐĵĽÐËûÕǺÃÁË¡£
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
×î½üѧϰasp£¬µ±Á·Ï°µ½Á¬½ÓÊý¾Ý¿âµÄʱºò£¬ÆµÆµ³ö´í£¬¿É¾ÍÊDz»ÖªµÀ´íÔÚÔõôµØ·½£¬Çë¸ßÊÖ°ïæ¿´¿´£¡£¡Ð»Ð»£¡
°üº¬Îļþxx.asp¡¢xxsave.asp¡¢conn.aspÒÔ¼°student1.mdbºÍ±íxxgl¡¡
xx.aspΪ£º
<html>
<hea ......
ÈçºÎÐÞ¸Ämsysobjects±íÖеÄÊý¾ÝÄØ£¿Ð»Ð»
ɶ¶¼Ã»ÓÐ,Òâ˼²»Ã÷È·,ÔÙÏêϸµã°É
²»Òª¸ÄsysobjectsÀïµÄ¶«Î÷¡£
ÓÃÆäËü·½·¨¸Ä£¬±íÃû»òÆäËû¡£
ÒªÔÚACCESS»·¾³ÏÂÅäÖÃȨÏÞ£¬²ÅÄÜ·ÃÎÊϵͳ±í...
лл´ó¼Ò¡£
ÊÇÕâÑù£¬¿´ ......
´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......