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Êý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
µÚÒ»´Î½Ó´¥CrystalReport
¼±Ñ°ÕÒVb.net Access ͨ¹ý²éѯ³öµÄÊý¾ÝÊä³öµ½CrystalReportµÄÀý×Ó.
ÓеÄÅóÓÑÂé·³·¢À´Ñ§Ï°.¶àл!
¸úÄãµÄÒªÇó²î²»¶à£¬²Î¿¼Ò»Ï£º
http://topic.csdn.net/u/20090823/21/87af02d3-f4ca-480 ......
ÎÒдÁËÒ»¸öÈí¼þ£¬ÒªÓõ½ACCESSÊý¾Ý¿â£¬ÎÒÔÙ·ÃÎÊACCESSµÄʱºò£¬ÎÒÐèÒª´Ó±íÀï¶Á³öÒ»ÐÐÊý¾Ý£¬ÎҵijÌÐòÊÇÕâÑùдµÄ£¬SQLSTRING="SELECT * from '" &ME.TEXTBOX1.TEXT &"' WHERE ID = '"& ......
´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......