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

ÐÂÊÖÎÊÌ⣬ÈçºÎÓôúÂëɸѡAccessµÄ¼Ç¼µ½ListBox£¿

ÒѾ­ÔÚform1ÖÐÊÖ¶¯ÅäÖúÍÁ¬½ÓºÃÁËMDBÊý¾Ý¿â£¬ÔÚform1ÖÐÓиöListbox1¿Ø¼þ£¬Óиö°´Å¥£¬µã»÷°´Å¥£¬°ÑAccesµÄ¼Ç¼¶Á³öÀ´£¬·ÅÈëµ½Listbox1£¬ÇëÎÊÔõô¸ã£¿
¹©²Î¿¼£º
Delphi(Pascal) code:

with adoquery1 do begin
close;sql.clear;
sql.add('select distinct F01 from aTableName order by F01');
open;
while not eof do begin
listbox1.items.add(fieldByName('F01').asstring);
next;
end;
end;




adoquery1.first;Õâ¸öÒ²µÃ¼ÓÉϰÉ

1Â¥µÄ¿ÉÒÔʵÏÖ£¬¾ÍÊÇ´úÂë²»Õ¦¸ö¹æ·¶£¬ÐÂÊÖҪעÒâ£¬Ñø³ÉºÃµÄϰ¹ß¡£


ÒýÓÃ
¹©²Î¿¼£º
Delphi(Pascal) codewith adoquery1dobegin
close;sql.clear;
sql.add('select distinct F01 from aTableName order by F01');
open;whilenot eofdobegin
listbox1.items.add(fieldByName('F01').asstring);
next;end;end;


ÎҾ͸ÄÒ»ÏÂ1Â¥Ðֵܵİɣ¬¶ÔÐÂÊÖÓеãÓðɡ£

begin
  ListBox1.Clear;
  with ADOQuery1 do begin
    SQL.Text := 'select distinct F01 from aTableName order by F01';
    Open;
    while not Eof do begin
      ListBox1.Items.Add(FieldByName('F01').AsString);
      Next;
    end;
    Close;
&nbs


Ïà¹ØÎÊ´ð£º

Access²éÕÒÖØ¸´ÎÊÌâ

ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏ 
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡± 
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......

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

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

accessÖеÄtextÐÍÊý×Ö - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

accessÖеÄtextÐ͵ÄÊý×Ö£¬Ôõô±È½Ï´óС°¡£¿
´ó¼ÒÖªµÀÂð?
ÒòΪÎÒÏë¸ù¾ÝÕâÒ»ÁÐÊý¾ÝµÄ´óС²éѯһЩ¶«Î÷
¾Ù¸öÀý×Ó£º
¾ÍÊÇ£¬ÎÒÓÐÒ»ÁÐÊý¾ÝΪ±àÂ룺
ÊÇtextÐ͵ÄÊý×Ö£ºÈç
1101
1102
1103
µÈ£¬
ÎÒÏÖÔÚҪȡ³ö±àÂë±È ......

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

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