Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÈçºÎ¸ü»»Êý¾ÝÔ´(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;

»»ÁËÊý¾Ý¿âÔõô²»ÏÔʾÊý¾Ý£¬ÎÒ¿âÀïÃæÓÐÊý¾Ý°¡£¬»»»ØÔ­À´µÄÊý¾Ý¿âÒ²²»ÏÔʾÄÚÈÝÁË


Ïà¹ØÎÊ´ð£º

ÈçºÎ´ÓACCESSÊý¾Ý¿âÖÐÒ»´Î²éѯ¶à¸ö±í²¢¼ÓÈëÊý¾Ý¼¯?

ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......

ACCESSÎı¾¿ò³¤¶ÈÊǶàÉÙ? - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤?
ÄãÊÇÔõÑù¸³ÖµµÄ£¿

²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û

ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......

²éѯaccessµÄÀÏÊÇÌáʾ²ÎÊý²»×ã

ÎÒ²éѯaccess£¨97£©µÄʱºòÀÏÊÇÌáʾ²ÎÊý²»×㣬µ«ÊÇÎÒÔÚaccess²éѯÕâÌõÓï¾äÊÇûÓдíÎóµÄ¡£ÊÇÔõô»ØÊÂÄØ£¿
SQL code:
SELECT * from wcj WHERE Pno = '3' And TRim(Conclusion) = 'ºÏ¸ñ' and (NET) is null

S ......

VC ADO ACCESS sql ²éѯ - VC/MFC / Êý¾Ý¿â

´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......

£¨ÔÚÏߵȴý£©ListBoxÖÐÏÔʾAccessÖ¸¶¨×ֶεļǼ

±¾ÈËÊǸÕѧϰDelphi×Å£¬ÏÖÓöµ½ÈçÏÂÒ»¸öÎÊÌ⣺
ÎÒÏëÔÚListBoxÖÐÏÔʾAccessÊý¾Ý¿âTB±íµÄPeople×Ö¶ÎÀïÃæµÄ¼Ç¼¡£
ÀýÈ磺
TB±íÖеÄ×Ö¶ÎPeopleÀïÃæ¼Ç¼£ºA,B,C,D......
ÔÚListBoxÖÐÏÔʾ£¬ListBox.Item[0]:=A
  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ