access Êý¾Ý¿â±ØÐëÌî¾ø¶Ô·¾¶Âð
Óà ADOConnection Á¬½ÓÒ»¸ö Access .mdb Êý¾Ý¿âʱ
ÔÚÊäÈëÊý¾Ý¿âÃû³ÆÊ±±ØÐëÊǾø¶Ô·¾¶Âð£¿
ÔÚBCB 6 ʱ£¬ ÎÒÖ»ÊäÈëÎļþÃû¾Í¿ÉÒÔÁË¡£ ÒòΪÎÒµÄ Êý¾Ý¿âÓëÓ¦ÓÃÔÚͬһ¸öĿ¼¡£
ÔÚ 2010 Èç¹ûÖ»ÌîÎļþÃû³Æ£¬ ÔÚÏ´ÎÖØÆôRS2010´ò¿ªÏîĿʱ£¬ÌáʾÕÒ²»µ½Îļþ ÈçÏÂ
ÕÒ²»µ½Îļþ ¡®C:\Documents and Settings\neeme\×ÀÃæ\clearsky.mdb.
ÎÒµÄÎļþ²»ÔÚÕâ¸öĿ¼£¬µ«ÎªÊ²Ã´»á¼ÓÉÏÕâ¸öÄ¿Â¼ÄØ£¿
µ÷ÊÔʱÄ㽫Êý¾Ý¿â·ÅÔÚDebug»òReleaseÎļþ¼ÐÀï
ÓëÄãÉú³ÉµÄexeÎļþÔÚÒ»¸öĿ¼.´Ó2006¿ªÊ±,Éú³ÉµÄÎļþ»á·ÅÔÚµ¥¶ÀµÄÒ»¸öÎļþ¼ÐÀï
ÔËÐÐʱûÓÐÎÊÌâµÄ¡£ ÎÒÒ²°ÑÊý¾Ý¿âÎļþÔÚµ½¶ÔӦĿ¼Àï
Ö»ÊÇÔÚÐÞ¸ÄÏîĿʱ£¬ RS2010 ³öÏÖÕâ¸öÌáʾ£¡
ÎÒ·¢¾õ ÔÚ welcom page ´ò¿ªÏîĿ¼ »áÓÐÕâ¸öÎÊÌâ
ÔÚ File -> open project ´ò¿ªÏîĿ¼£¬ ûÓÐÕâ¸öÎÊÌâ
Èç¹û²»ÐÐÄã¿ÉÒÔÔÚÉè¼ÆÊ±Ê¹ÓÃÕâЩ
String DBFile = ExtractFilePath(Application->ExeName)+"\\clearsky.mdb";
String Provider1="Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+DBFile+";Jet OLEDB";
ADOConnection->ConnectionString = Provider1;
ADOConnection->Open() ;
String Provider1="Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+DBFile;
×î½üÀÏÊdzö´í
ÎÒ²ÂÊÇ£¬Óà welcome page ÕÒ¿ªÏîÄ¿£¬ ¹¤³ÌµÄĬÈÏĿ¼Ϊ
C:\Documents and Settings\neeme\×ÀÃæ\
Óà File->Open Project ÕÒ¿ªÏîÄ¿£¬ ¹¤³ÌµÄĬÈÏĿ¼Ϊ
¹¤³ÌµÄµ±Ç°Ä¿Â¼£
Ïà¹ØÎÊ´ð£º
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
CREATE TABLE Product(model integer,
maker varchar(20),
CONSTRAINT SAND PRIMARY KEY (model),
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model)
ON DELETE CASCADE ......
Çë´óÏÀÖ¸µã£¬¹òлÁË£¬×îºÃÓдúÂë
ÒªÓõ½ADOX¶ÔÏ󣬲éϰïÖúÎĵµ£¬
http://hyadliujing.blog.163.com/blog/static/4484507420091020969233/?mode=edit
ûÓÐÕÒµ½°¡ ¿´ÁËÄãµÄ²©¿ÍÁË£¬ÎÒÊÇÏ뽫accessÀïÃæµÄ¸½¼þ±£´æ ......
ÎÊÌ⣱
ÎÒÓÃADOÁ¬½ÓÉèÁËÓû§ÃûÃÜÂëµÄÊý¾Ý¿â
µ«ÊÇÎÒ·¢ÏÖÎÒ²»ÊäÈë Óû§ÃûºÍÃÜÂë ¶¼¿ÉÒÔÁ¬½Ó³É¹¦ ¶øÇÒ»¹ÄܰÑÊý¾Ý¶Á³öÀ´
¼ôÁËÒ»¸öÃûΪtestÊý¾Ý¿â ½¨ÁËÒ»¸öÃûΪpeopleµÄ±í
¼ûÁËÒ»¸ö Óû§Ãû1234 ÃÜÂë1234 µÄ ......
accessÖеÄtextÐ͵ÄÊý×Ö£¬Ôõô±È½Ï´óС°¡£¿
´ó¼ÒÖªµÀÂð?
ÒòΪÎÒÏë¸ù¾ÝÕâÒ»ÁÐÊý¾ÝµÄ´óС²éѯһЩ¶«Î÷
¾Ù¸öÀý×Ó£º
¾ÍÊÇ£¬ÎÒÓÐÒ»ÁÐÊý¾ÝΪ±àÂ룺
ÊÇtextÐ͵ÄÊý×Ö£ºÈç
1101
1102
1103
µÈ£¬
ÎÒÏÖÔÚҪȡ³ö±àÂë±È ......