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ºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
ÕâÁ½Ììѧϰ¡¶Delphi¼¼Êõ·½°¸±¦µä¡·Ò»ÊéÖеÚÈýÕ¹ØÓÚÓû§µÇ¼·½°¸µÄÀý×Ó£¬ÀûÓõÄÊÇSQl ServerÊý¾Ý¿âʵÏÖÓû§µÇ¼£¬±àÒëÔËÐж¼Ã»ÎÊÌ⣬¸ÃʵÏֵŦÄÜÒ²¶¼ÊµÏֵĺܺ㬵«ÊÇÆæ¹ÖµÄÊÇ£¬·´¸´ÔËÐÐÒ»¶Îʱ¼äºó£¬ÓÐʱÔڹرÕÕû¸ö ......
Çë¸÷λָµãÏ£º³ÌÐò´úÂëÈçÏÂmingchen = "C:\Îļþ·¾¶\"
cat = New ADOX.Catalog
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & min ......
Âé·³¸÷λ°ïæ¿´¿´°¡
´úÂëÈçÏ£º
CoInitialize(NULL);
_ConnectionPtr pConn(__uuidof(Connection));
_RecordsetPtr pRst(__uuidof(Recordset));
pConn->ConnectionString="Provider ......
jsp¿ª·¢µÄʱºòÄܹ»µ¼³öwordºÍexcel£¬µ«ÊÇÊÇ·ñÄܹ»Ö±½Óµ¼³öΪacess¸ñʽ¡¢dbf¸ñʽµÄÎļþ£¿
¸ßÊÖÖ¸µãÏ£¬×îºÃÄܹ»¸ø¸öÀý×Ó£¬Ð»Ð»£¡£¡£¡
javadbfÕâ¸öjarÒ»ÇÐÎÊÌâ½â¾öÁË¡£
ÏÂÔصØַΪ£ºhttp://sarovar.org/projects/ ......