ÐÂÊÖÎÊÌ⣬ÈçºÎÓôúÂëɸѡ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Êý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏ ±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡± ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
accessÖеÄtextÐ͵ÄÊý×Ö£¬Ôõô±È½Ï´óС°¡£¿ ´ó¼ÒÖªµÀÂð? ÒòΪÎÒÏë¸ù¾ÝÕâÒ»ÁÐÊý¾ÝµÄ´óС²éѯһЩ¶«Î÷ ¾Ù¸öÀý×Ó£º ¾ÍÊÇ£¬ÎÒÓÐÒ»ÁÐÊý¾ÝΪ±àÂ룺 ÊÇtextÐ͵ÄÊý×Ö£ºÈç 1101 1102 1103 µÈ£¬ ÎÒÏÖÔÚҪȡ³ö±àÂë±È ......
ÎÒ»ú×ÓÀïÃæÃ»ÓÐACCESS,ÇëÎÊÔÚ²»ÖØ×°ÏµÍ³µÄÇé¿öϸÃÈçºÎ°ÑËü×°ÉÏ,֮ǰÎÒÊÔ×°¹ýÆäËü°æ±¾µÄSP3 OFFICE,µ«»¹ÊÇ×°²»ÉÏ, ÇëÎÊÓÐʲôºÃ°ì·¨Âð? °²×°OFFICE £¬Ñ¡Ôñ°²×°ACCESS¾Í¿ÉÒÔѽ ¡£ ÒýÓà °²×°OFFICE £¬Ñ¡Ôñ°²×° ......
rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬ËÄܸøµãÌáʾ£¿Ð»Ð» ÄãÔõôÁ¬µÄ£¿ AccesÊý¾Ý¿â.. ÄãÔõôÁ·µÄÄØ£¿ Java code: static String DBDRIVER = "sun.jd ......
ÎÒÊÖ¶¯Ìí¼Ó»ùÓÚCRecordSetÀàµÄÅÉÉúÀàCODBCDemoSetÀà,ÊÇÀûÓÃclass wizardÌí¼ÓµÄ¡£²¢ÇÒ¶¨ÒåÁËÒ»¸öÈ«¾Ö±äÁ¿CODBSDemoSet*m_pCommon.µ«ÊÇÎÒ³ÌÐò²»ÄÜÔËÐС£ÎÒ¸ú×ÙÁËһϣ¬µ½ÁËm_pCommon->Isopen£¨£©´¦·¢Éú´íÎ󣬣 ......