¹ØÓÚ¹²ÏíaccessÊý¾Ý¿âµÄÎÊÌâ
ÎÒÐèҪд¸ö³ÌÐòÔÚB»úÉÏ´ò¿ªAÉϵÄaccessÊý¾Ý¿â£¬¶ÁЩÊý¾Ý£¬ÎÒ°ÑAÉϵÄĿ¼¹²ÏíÁË£¬µ«ÊÇÔÚ¶ÁµÄʱºòÌáʾ˵AÉϵÄÊý¾Ý¿âÕýÒÔ¶ÀÕ¼µÄ·½Ê½´ò¿ª£¬²»³É¹¦¡£ÕâʱºòA¸Õ¿ª»ú£¬AÉϵijÌÐò²¢Ã»Óдò¿ª£¬ÊDz»ÊÇÓÐפÁô½ø³ÌÔÚÓÃAµÄÊý¾Ý¿â£¿Óöµ½ÕâÖÖÇé¿öÎÒ¸ÃÔõô°ì£¿ ÎÒÏ£ÍûÄÜÔÚA»úÆ÷´ò¿ª³ÌÐòµÄʱºò£¬BÒ²ÄܶÁÊý¾Ý¿â£¬ÕâÒªÔõô×ö£¿ лл
ºÃµÄ£¬ÎÒÈ¥¿´Ò»Ï¡£ ¼ì²éÒ»ÏÂÄãµÄ³ÌÐòµÄ´ò¿ª·½Ê½£¬ÉèÖÃΪʹÓù²Ïíģʽ´ò¿ª¡£ÒýÓà ÎÒÐèҪд¸ö³ÌÐòÔÚB»úÉÏ´ò¿ªAÉϵÄaccessÊý¾Ý¿â£¬¶ÁЩÊý¾Ý£¬ÎÒ°ÑAÉϵÄĿ¼¹²ÏíÁË£¬µ«ÊÇÔÚ¶ÁµÄʱºòÌáʾ˵AÉϵÄÊý¾Ý¿âÕýÒÔ¶ÀÕ¼µÄ·½Ê½´ò¿ª£¬²»³É¹¦¡£ÕâʱºòA¸Õ¿ª»ú£¬AÉϵijÌÐò²¢Ã»Óдò¿ª£¬ÊDz»ÊÇÓÐפÁô½ø³ÌÔÚÓÃAµÄÊý¾Ý¿â£¿Óöµ½ÕâÖÖÇé¿öÎÒ¸ÃÔõô°ì£¿ ÎÒÏ£ÍûÄÜÔÚA»úÆ÷´ò¿ª³ÌÐòµÄʱºò£¬BÒ²ÄܶÁÊý¾Ý¿â£¬ÕâÒªÔõô×ö£¿ лл Èç¹ûÊÇÓÃF/Sģʽ¹²ÓÃMDB£¬ÓÐÕâ¸öÏÖÏ󣬽¨ÒéÓÃADOÁ¬½ÓMDB£¬ÔÙ²Ù×÷ ÎÒÓõľÍÊÇado.netµÄÁ¬½Ó·½Ê½£¬datasetµÄ£¬ÕâÑùÐÐÂ𣿠ʲôÑùµÄ¿ÉÒÔÄØ£¿ Á¬½Ó´úÂëÊÇʲô£¿ OleDbConnection insdb = new OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=\\\\jiance\\²â¹¦»úϵͳ\\CegongMachine.mdb"); ¾ÍÊÇÕâ¸ö jianceÊÇ»úÆ÷Ãû ldb ÎļþÊÇ·ñ´æÔÚ£¿ÄÚÈÝÊÇʲô£¿ Ŀ¼¡¢ÎļþÊÇ·ñÓзÃÎÊȨÏÞ£¬¼ì²éһϠÎÒÈ¥¿´ÁËһϣ¬ÀïÃæÃ»ÓÐldbÎļþ£¬ÎÒÓÃaccess´ò¿ª£¬¾ÍÓÐldbÎļþÁË£¬ ÀïÃæÊÇ" jiance admin ",jiance ÊÇ»úÆ÷Ãû admin ÊÇÄǸö³ÌÐòµÄµÇ¼Ãû¡£ A»úÉϵÄÄǸö³ÌÐò²»ÊÇÎÒ±àµÄ£¬B»úÉϵÄÊÇ£¬ÐèÒªÓÃA»úÉϵÄÊý¾Ý¿â ÒÔǰµ÷ÊÔµÄʱºò¶¼ÊÇÓÿ½¹ýÀ´µÄ¸±±¾£¬ÏÖÔÚµ÷ÊÔµÄʱºò²»ÐÐÁË£¬ËµÊÇ
Ïà¹ØÎÊ´ð£º
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺 £¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£® µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
Çë¸÷λָµãÏ£º³ÌÐò´úÂëÈçÏÂ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 ......
CREATE TABLE Product(model integer, maker varchar(20), CONSTRAINT SAND PRIMARY KEY (model), CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model) ON DELETE CASCADE ......