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£¬ÄǾͷÅÐĵĽÐËûÕǺÃÁË¡£
Ïà¹ØÎÊ´ð£º
ÈçºÎÐÞ¸Ämsysobjects±íÖеÄÊý¾ÝÄØ£¿Ð»Ð»
ɶ¶¼Ã»ÓÐ,Òâ˼²»Ã÷È·,ÔÙÏêϸµã°É
²»Òª¸ÄsysobjectsÀïµÄ¶«Î÷¡£
ÓÃÆäËü·½·¨¸Ä£¬±íÃû»òÆäËû¡£
ÒªÔÚACCESS»·¾³ÏÂÅäÖÃȨÏÞ£¬²ÅÄÜ·ÃÎÊϵͳ±í...
лл´ó¼Ò¡£
ÊÇÕâÑù£¬¿´ ......
accessÖеÄtextÐ͵ÄÊý×Ö£¬Ôõô±È½Ï´óС°¡£¿
´ó¼ÒÖªµÀÂð?
ÒòΪÎÒÏë¸ù¾ÝÕâÒ»ÁÐÊý¾ÝµÄ´óС²éѯһЩ¶«Î÷
¾Ù¸öÀý×Ó£º
¾ÍÊÇ£¬ÎÒÓÐÒ»ÁÐÊý¾ÝΪ±àÂ룺
ÊÇtextÐ͵ÄÊý×Ö£ºÈç
1101
1102
1103
µÈ£¬
ÎÒÏÖÔÚҪȡ³ö±àÂë±È ......
ÍøÉÏÕÒµ½µÄ¶¼ÊÇasp.net
ÓÐûÓÐaspµÄµ¼Èëµ¼³öÍêÕû´úÂë
ÒýÓÃ
CSDNÉÏÄãËÑËÑ ¾ÍÓкܶà Õâ¸öÊǵ¼³öhttp://topic.csdn.net/u/20100104/10/fd959988-1ea6-46eb-9fe3-c4fe0e5ba234.html?8966
²»ÊÇµÄ ÎÒÏÖÔÚÄܵ¼ÈëºÍµ¼³ ......
ÎÊÌâÊÇÕâÑùµÄ,ÏÖÔÚÓÐÒ»¸ö¹¤×ʱí,ÊÇEXCELµÄ,ÎÒÒª°ÑËüµ¼ÈëACCESS,ÒòΪ Òª²éѯÿ¸öÈ˵Ť×Ê,¸ù¾Ý²»Í¬µÄ±àºÅ¿ÉÒÔ²éѯµ½Ïà¶ÔµÄÈË,
ÓÃASP Ôõô½«EXCELµ¼Èëµ½ACCESS,¶øÇÒÿÔ¶¼Óв»Í¬µÄ±í,
ÒýÓÃ
Æäʵ¾ÍÊÇ°ÑEXCELµ±³ÉÊý ......
´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éѯÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......