Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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¼¶Áª¸üÐÂÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / 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 ......

aspÁ¬½ÓACCESSÊý¾Ý¿âµÄÎÊÌ⣡£¡

×î½üѧϰasp£¬µ±Á·Ï°µ½Á¬½ÓÊý¾Ý¿âµÄʱºò£¬ÆµÆµ³ö´í£¬¿É¾ÍÊDz»ÖªµÀ´íÔÚÔõôµØ·½£¬Çë¸ßÊÖ°ïæ¿´¿´£¡£¡Ð»Ð»£¡
°üº¬Îļþxx.asp¡¢xxsave.asp¡¢conn.aspÒÔ¼°student1.mdbºÍ±íxxgl¡­¡­
xx.aspΪ£º
<html>
<hea ......

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

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

²éѯACCESSÖзûºÏÌõ¼þ¼Ç¼µÄÓï·¨¸ñʽ

ÎÒ×öÁËÒ»¸öС³ÌÐò£¬ÏëʵÏֵŦÄܾÍÊÇÔÚÎı¾¿òÖÐÊäÈëÐÕÃû£¬µã»÷²éѯ°´Å¥£¬¾ÍÄܲ鵽ACCESSÊý¾Ý¿âÖдËѧÉúµÄÐÅÏ¢£¨±àºÅ£¬ÐÕÃû£¬ÐÔ±ð£¬ÄêÁ䣩¿ÉÎÒ²»ÖªµÀÓï·¨¸ñʽ£¬ÎÒ×Ô¼ºÐ´µÄÓï¾äµ÷ÊÔÄÜͨ¹ý£¬¿ÉÊÇÔËÐÐʱ³ö´í£¨µã»÷²éѯ°´ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ