VCÁ¬½ÓACCESSÊý¾Ý¿âÎÊÌâ - VC/MFC / Êý¾Ý¿â
ÎÊÌ⣱
ÎÒÓÃADOÁ¬½ÓÉèÁËÓû§ÃûÃÜÂëµÄÊý¾Ý¿â
µ«ÊÇÎÒ·¢ÏÖÎÒ²»ÊäÈë Óû§ÃûºÍÃÜÂë ¶¼¿ÉÒÔÁ¬½Ó³É¹¦ ¶øÇÒ»¹ÄÜ°ÑÊý¾Ý¶Á³öÀ´
¼ôÁËÒ»¸öÃûΪtestÊý¾Ý¿â ½¨ÁËÒ»¸öÃûΪpeopleµÄ±í
¼ûÁËÒ»¸ö Óû§Ãû1234 ÃÜÂë1234 µÄÓû§
ÎÒÕÕ×ÅÊéÉϳÌÐòдµÄ ´ó¸ÅÊÇÕâÑù
_ConnectionPtr pConnection;
pConnection.CreateInstance(__uuidof(Connection));
m_pConnection->Open("test;","","",adModeUnknown);
ºóÃæÊǶÈÊý¾Ý
ÎÒÆæ¹Ö£¬ÎÒÃ÷Ã÷ÉèÁËÓû§ÃûºÍÃÜÂëΪʲô»¹ÄÜÁ¬½Ó³É¹¦£¬¶øÇÒ»¹°ÑÊý¾Ý¶Á³öÀ´£¬Ä¬ÈÏÓû§ "¹ÜÀíÔ±" ÎÒÒ²ÉèÁËÃÜÂë
ÎÊÌ⣲
Èç¹ûÎÒ°Ñ¿âÃûд´í£¬³ÌÐòÖ±½Ó³ö´íÖÕÖ¹
m_pConnection->Open("1111;","","",adModeUnknown);
ÎÒÏë²»ÈóÌÐòÖÕÖ¹£¬ÎÒÏë³öÏÖÒ»¸öÌáʾºó£¬ÖØÐÂÊäÈëÒ»¸öÊý¾Ý¿âÃû£¬Ó¦¸ÃÔõôд£¿
if(pConnection->Open(_bstr_t(strConnect), "", "", adModeUnknown) != S_OK) £¨ÎÒÕâÑù²»ÐУ©
ÄãÓÐûÓн¨Á¢testµÄODBCÁª½ÓÊý¾ÝÔ´?
ÎÊÌâ2
°Ñ³ö´íµÄµØ·½TRY¡£¡£¡£CATCH¡£¡£¡£Ò»Ï£¬³ö´íÖ®ºóÖØд¦Àí
¶ÔÁË£¬sj.dat Æäʵ¾ÍÊǸö ±£´æÁËÊÖ»ú¹éÊôµØµÄaccessÊý¾Ý¿â¡£
²»Ã÷°×°¡
ADOÁ¬½ÓÊý¾Ý¿â²»ÐèÒªODBCÊý¾ÝÔ´°É
¸÷λ´óÏÀ°ï°ï棬Õâ¸öÎÊÌâÒѾÀ§ÈźþÃÁË¡£ÍøÉϵÄÀý×Ó»ù±¾É϶¼¿´¹ýÁË»¹Êǽâ¾ö²»ÁË
´úÂëÔÚ¹«Ë¾£¬Éϲ»ÁËÍø ¡£
ÆäʵÎÒ¾ÍÊÇÏëʵÏÖÁ½¸ö¹¦ÄÜ
1£©½¨Á¢Ò»¸öÊý¾Ý¿âÓû§£¬µÇ½µÄʱºò±ØÐëÖªµÀÓû§ÃûÃÜÂë²ÅÄܵǽ£¬ÒÔÇ°ÊÇÔÚÊý¾Ý¿âÖн¨Ò»ÕÅ±í±£´æÓû§£¬ÃÜÂ룬ÒòΪֻҪÓÐ2£¬3¸öÓÃ
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æʱ¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
Êý¾Ý¿âÁ¬½ÓÌáʾÈçϱ¨´í£¬¿´µÄ³öÀ´ÊÇÒ³ÃæÓëÊý¾Ý¿âÁ¬½ÓµÄÎÊÌ⣬ÏÖÔÚÎÒµÄÊÇÏà¶ÔÁ¬½Ó¡£
ÒªÔõô½«Æä¸Ã³É¾ø¶ÔÁ¬½ÓÄØ£¿ÎÒµÄÊý¾Ý¿âÎļþ·¾¶ÔÚ£º
D:\web\db
»¹ÊÇÒªÏÈлл´óÈËÃÇ°ïÖúС°×²ËÎÒ
Microsoft O ......
µÚÒ»´Î½Ó´¥CrystalReport
¼±Ñ°ÕÒVb.net Access ͨ¹ý²éѯ³öµÄÊý¾ÝÊä³öµ½CrystalReportµÄÀý×Ó.
ÓеÄÅóÓÑÂé·³·¢À´Ñ§Ï°.¶àл!
¸úÄãµÄÒªÇó²î²»¶à£¬²Î¿¼Ò»Ï£º
http://topic.csdn.net/u/20090823/21/87af02d3-f4ca-480 ......
ÈçºÎÐÞ¸Ämsysobjects±íÖеÄÊý¾ÝÄØ£¿Ð»Ð»
ɶ¶¼Ã»ÓÐ,Òâ˼²»Ã÷È·,ÔÙÏêϸµã°É
²»Òª¸ÄsysobjectsÀïµÄ¶«Î÷¡£
ÓÃÆäËü·½·¨¸Ä£¬±íÃû»òÆäËû¡£
ÒªÔÚACCESS»·¾³ÏÂÅäÖÃȨÏÞ£¬²ÅÄÜ·ÃÎÊϵͳ±í...
лл´ó¼Ò¡£
ÊÇÕâÑù£¬¿´ ......
ÎÒÔÚǰ̨ҳÃæÊäÈë¿òÊäÈë 20091208 µã»÷Ìá½»Ö®ºó±¨´í,˵ÀàÐͲ»Æ¥Åä.
Êý¾Ý¿âÀï Õâ¸ö×ֶεĸñʽӦ¸ÃÊÇ 2009-12-8 14:27:40
ÊDz»ÊÇÒª°Ñ 20091208 ת»»³É¸ñʽ 2009-12-8 14:27:40
ÇëÎÊÎ ......