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Êý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
ÕâÁ½Ììѧϰ¡¶Delphi¼¼Êõ·½°¸±¦µä¡·Ò»ÊéÖеÚÈýÕ¹ØÓÚÓû§µÇ¼·½°¸µÄÀý×Ó£¬ÀûÓõÄÊÇSQl ServerÊý¾Ý¿âʵÏÖÓû§µÇ¼£¬±àÒëÔËÐж¼Ã»ÎÊÌ⣬¸ÃʵÏֵŦÄÜÒ²¶¼ÊµÏֵĺܺ㬵«ÊÇÆæ¹ÖµÄÊÇ£¬·´¸´ÔËÐÐÒ»¶Îʱ¼äºó£¬ÓÐʱÔڹرÕÕû¸ö ......
²éÁ˺ó¤ºÃ³¤Ê±¼ä£¬ÎÊÌâÖÕÓÚ½â¾ö£¬Ï£ÍûÓÐÕâÑùµÄÎÊÌâµÄÅóÓÑÉÙ×ßЩÍä·¡£
×¢Ò⣬ÎÒÕâÀïʱºòËù˵µÄÊÇÖ»ÓÐÒýÓÃÊý¾Ý¿âµÄÖÐÎÄÂÒÂë£¬Ò³ÃæÆäËûÖÐÎÄÕý³££¬ÆäËûÇé¿öÔò²»Ò»¶¨ÊÊÓá£
ÔÚÏÖÊµÒ³Ãæ×î¶¥¶Ë¼ÓÈëÏÂÃæÁ½¾ä£º
......
Çë´óÏÀÖ¸µã£¬¹òлÁË£¬×îºÃÓдúÂë
ÒªÓõ½ADOX¶ÔÏ󣬲éϰïÖúÎĵµ£¬
http://hyadliujing.blog.163.com/blog/static/4484507420091020969233/?mode=edit
ûÓÐÕÒµ½°¡ ¿´ÁËÄãµÄ²©¿ÍÁË£¬ÎÒÊÇÏ뽫accessÀïÃæµÄ¸½¼þ±£´æ ......