×°ÁËϵͳ£¬ÏµÍ³Ã»ÓÐÊý¾Ý¿â¡£Ïëдһ¸öÈÕ³ÌÌáÐѳÌÐò¡£ÓÃAccess×÷Êý¾Ý´æ´¢¡£ÓÃC#Á¬½ÓÊý¾Ý¿â£¬²åÈë±í¡¢Êý¾ÝµÈ²Ù×÷ÎÒÒѾ»áÁË¡£µ«ÊÇËäȻֱ½ÓÁ¬½ÓҲûʲô£¬µ«ÊÇ×ܸоõ²»¹»ÍêÉÆ¡£ÏëÓÃC#À´´´½¨Ò»¸öÐèÒªÃÜÂë²ÅÄÜ·ÃÎʵÄÊý¾Ý¿â¡£¼´ÔÚ²Ù×÷ϵͳÏÂÖ±½Ó·ÃÎÊAccessÊý¾Ý¿âÒªÊäÈëÃÜÂë¡£ÍøÉϲéÁË£¬²»ÊÇ˵ÔõôÁ¬½ÓµÄ£¬¾ÍÊÇÔõô²Ù×÷µÄ£¬¾ÍÊÇûÓÐ ......
±ÈÈç access Êý¾Ý¿â A ÀïµÄÊý¾Ý µ¼Èëµ½ BÊý¾Ý¿â£¬ÎÒÔõôŪ°¡£¿
select * into [;database=b.mdb].tt from [;database=a.mdb].tt
ÔÚA¿âÖпÉÒÔÖ±½ÓÖ´ÐÐ
SQL code:
select * into [c:\temp\b.dmb].table1 from tabl1
Èç¹ûÊÖ¹¤µÄ»°£¬
Äã¿ÉÒÔ´ò¿ªA¿â£¬È»ºó´Ó²Ëµ¥£¬ Îļþ ¡·µ¼È ......
ÎÒ ÍøÕ¾µÄ access Êý¾Ý¿â 8ÔµÄʱºò 11M ÏÖÔÚ±ä³É18MÁË¡£²»ÖªµÀÊÇÔõô»ØÊ£¿ ÊDZ»±ðÈ˹¥»÷ÁËÂð£¿ÎÒ¸ÄÈçºÎ¼ì²éÎÞÓÃÐÅÏ¢ £¬ÇåÀíÀ¬»øÊý¾Ý
ÏÈѹËõÒ»ÏÂMDB£¬¿´¿´Ìå»ý¼õÉÙûÓÐ
ACCESSÖе±Äãɾ³ý¼Ç¼»ò¶ÔÏóµÄʱºò£¬ÕâЩ±»É¾³ýµÄ¶ÔÏóËùÕ¼ÓõĴÅÅ̿ռ䲻»á±»×Ô¶¯ÊÍ·Å£¬ÐèÒªÄãÊÖ¹¤À´Ñ¹Ëõ¡£
¹ØÓÚ Access ÎļþµÄѹËõ ......
Êý¾Ý¿âÖÐÓÐÁ½Õűí Ò»¸ö±íÃû quzi Ò»¸ö±íÃûquSort£¬quSort±íÖеÄqsID×Ö¶ÎÊÇÖ÷¼ü quzi±íÖеÄqsidÊÇqsIDµÄÍâ¼ü
ÎÒÏëʵÏÖµÄÊÇÔÚquzi±íÖÐÌí¼Ó»òɾ³ýÒ»Ìõ¼Ç¼ʱ£¬µ÷ÓÃÕâ¸ö·½·¨£¬ÈÃquSort±í¼ÓÉÏ»ò¼õÈ¥Ò»Ìõ¼Ç¼¡£´úÂëÈçÏ£º
C# code:
public static void UpdateCount(string tabelName,string addOrRed,string idNa ......
±¾ÈË×öÁËÒ»¸ö¸ü¸ÄÃÜÂëµÄBUTTON£¬ÔÚ´°ÌåÉÏÃæ»¹ÓÐÒ»¸öTEXTBOX¿Ø¼þ£¬ºǫ́Êý¾Ý¿âÓõÄÊÇACCESS£¬ÏÖÔÚÎÊÌâÈçÏ£ºµã»÷¸ü¸ÄÃÜÂëµÄBUTTONºó£¬TEXTBOXÏÔʾ¸ü¸ÄºóµÄÃÜÂëBBB,£¨ÔÃÜÂëÊÇAAA£©£¬µ«ÊÇÎҹصô´°ÌåºóÔÙÖØÐÂÖ´ÐУ¬Ö±½Óµã»÷ÏÔʾÃÜÂëµÄBUTTON£¬TEXTBOX»¹ÊÇÏÔʾδ¸ü¸ÄµÄÃÜÂëAAA£»ºÃÏñ¾ÍÊdzÌÐòÖ´Ðж¼Ã»ÓÐÎÊÌ⣬µ«ÊǾÍÊDz»Äܽ«ACCES ......
ÓÐÒ»¿Í»§ÍøÕ¾£¬¼¸ºõÿÌì¶¼»á¶ªÊ§¼¸ÌõÉõÖÁÉÏÊ®Ìõ¼Ç¼£¬ÕâЩ¼Ç¼һ°ã¶¼ÊÇÐÂÌí¼ÓµÄÉÌÆ·¡£¼ì²é¹ý³ÌÐò£¬·¢ÏÖûʲôÎÊÌ⣬ҲûÓз¢ÏÖÈκοÉÒɵÄÎļþ,²¢ÇÒ½«Êý¾Ý¿âÃûÒ²¸ÄÁË£¬½«ºǫ́ÕʺÅÒ²¶¼¸ÄÁË£¬È·±£Ö»ÓÐ×Ô¼ºÒ»¸öÈËÖªµÀ£¬¹ýÁËÒ»Á½Ì죬Êý¾Ý»¹ÊÇÕÕÑù¶ªÁË¡£±¾È˹À¼ÆÊÇÓÐÈ˹ÊÒâ¸ãµÄ£¬ÔÚ´ËÇë½Ìϸ÷λ´óÏÀ£¬ÕâÖÖÈçºÎÈçºÎ½â¾ö£¿±ðÈËÒ»°ãÍ ......