ÈçºÎ¸ü»»Êý¾ÝÔ´(Access)
ÀýÈçÓÐ2¸öÊý¾Ý¿â£¬a.mdbºÍb.mdb£¬¸Õ¿ªÊ¼ÓõÄa.mdb,ÈçºÎд³ÌÐòÑ¡Ôñb.mdb¿ÉÓà ³ÌÐòÓÐÓû§µÇ¼ÓëûÓû§µÇ¼ÊDz»ÊÇÓÐÇø±ð
Çл»Êý¾Ý¿â¾ÍÊǸıäadoconnectionµÄconnectionstringÖеÄÊý¾ÝÔ´¾ÍÊÇÁË ÓÃÁ½¸öÁ¬½Ó»ò¸ü¸ÄÁ¬½Ó´® adoconnection jf data source='+OpenDialog1.FileName+'; adoconnection.connectionstring:=data source; ÕâÑùдÒýÓà data source='+OpenDialog1.FileName+'; adoconnection.connectionstring:=data source; ÕâÑùд ÕâÊÇɶ£¿data source£¬lz¿ÉÄÜÓÐЩ¶«Î÷û¸ãÇå³þ¡£ Constr : string; Constr= 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=.\Data.mdb;Persist Security Info=False'; adoconnection.connectionstring:=Constr; ÏòÕâÑù×¼±¸2¸öÁ´½Ó×Ö·û´®£¬·Ö±ðÖ¸ÏòÄã2¸ö²»Í¬µÄÊý¾Ý¿â ÎÒÊÇÏëÔËÐгÌÐòʱ¸Ä±äÊý¾Ý¿â Êý¾Ý¿âÃû³Æ²»¹Ì¶¨ÒýÓà ¸ø·Ö½áÌù°É var Constr:string; begin adoconnection.active:=false; Constr:=Format('Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s;Persist Security Info=False',['Data.mdb']); adoconnection.connectionstring:=Constr; end; »»ÁËÊý¾Ý¿âÔõô²»ÏÔʾÊý¾Ý£¬ÎÒ¿âÀïÃæÓÐÊý¾Ý°¡£¬»»»ØÔÀ´µÄÊý¾Ý¿âÒ²²»ÏÔʾÄÚÈÝÁË
Ïà¹ØÎÊ´ð£º
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺 £¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£® µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤? ÄãÊÇÔõÑù¸³ÖµµÄ£¿ ²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......
ÎÒ²éѯaccess£¨97£©µÄʱºòÀÏÊÇÌáʾ²ÎÊý²»×㣬µ«ÊÇÎÒÔÚaccess²éѯÕâÌõÓï¾äÊÇûÓдíÎóµÄ¡£ÊÇÔõô»ØÊÂÄØ£¿ SQL code: SELECT * from wcj WHERE Pno = '3' And TRim(Conclusion) = 'ºÏ¸ñ' and (NET) is null S ......
´ó¼Ò°ïÏÂæÁË Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ ±ÈÈçÎÒÏÖÔÚ²éѯ SELECT * from XS WHERE רҵÃû='¼ÆËã»ú' ²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿ ±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......
±¾ÈËÊǸÕѧϰDelphi×Å£¬ÏÖÓöµ½ÈçÏÂÒ»¸öÎÊÌ⣺ ÎÒÏëÔÚListBoxÖÐÏÔʾAccessÊý¾Ý¿âTB±íµÄPeople×Ö¶ÎÀïÃæµÄ¼Ç¼¡£ ÀýÈ磺 TB±íÖеÄ×Ö¶ÎPeopleÀïÃæ¼Ç¼£ºA,B,C,D...... ÔÚListBoxÖÐÏÔʾ£¬ListBox.Item[0]:=A ......