VC+ADO²Ù×÷accessÊý¾Ý¿âÎÊÌâ
VC+ADO²Ù×÷accessÊý¾Ý¿âÎÊÌ⣬ÔËÐкóÏòaccess±íÖвåÈëÁ˼¸ÌõÊý¾Ý£¬È»ºóÎÒ½«±íÖеÄÊý¾Ý°´ÐÕÃûÅÅÐò£¬µ«µ±ÎÒÔÙÓóÌÐò¶ÁÈ¡±íµÄ¼Ç¼ʱ£¬¼Ç¼ÏÔʾµÄ˳Ðò¸úÅŹýÐòµÄ±íÖмǼ˳Ðò²»Ò»Ñù£¬ÎÒÏëÒª¶ÁÈ¡¼Ç¼µÄ˳ÐòºÍ±íÖеÄÒ»ÑùÓ¦¸ÃÔõô×öÄØ£¿Çó´óϺ°ï°ï棬ÎÒ·Ö²»¶àÁË£¬È«¸øÁË£¡
ÊÔÊÔÕâÑù²éѯ£º SELECT * from 'YourTable' ORDER BY 'Name' ÒýÓà ÊÔÊÔÕâÑù²éѯ£º SELECT * from 'YourTable' ORDER BY 'Name' Ŷ ллÄ㣡ÎÒÏëÔÙÇë½Ìһϣ¬ÎªÊ²Ã´±í¸ñÀïÒѾÅÅÁË˳ÐòÁË£¬µ«¶ÁÈ¡µÄ¼Ç¼ûÓа´ÕÕ±í¸ñÀïµÄ˳ÐòÄØ£¿
Ïà¹ØÎÊ´ð£º
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
DbgridÁ¬½Óaccess ÏÔʾÊý¾ÝʱÍ϶¯¹ö¶¯ÌõËÀ»ú£¿Ôõô½â¾ö°¡£¿ »úÆ÷Ì«²îÁ˰ɣ¿ ÊDz»ÊÇÄãÊý¾ÝÁ¿Ì«´óÁ˰¡ ÄãÊý¾ÝÉÙһЩ¿´¿´»¹ËÀ»úÂ𣿠Êý¾ÝºÜÉÙ°¡ ¾ÍÒ»Ò³¡£ ÎÒÔÚBCB6ÏÂ×ö¹ý²»ÉÙ DBGRID+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 ......
ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤? ÄãÊÇÔõÑù¸³ÖµµÄ£¿ ²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......
ÎÒ»ú×ÓÀïÃæÃ»ÓÐACCESS,ÇëÎÊÔÚ²»ÖØ×°ÏµÍ³µÄÇé¿öϸÃÈçºÎ°ÑËü×°ÉÏ,֮ǰÎÒÊÔ×°¹ýÆäËü°æ±¾µÄSP3 OFFICE,µ«»¹ÊÇ×°²»ÉÏ, ÇëÎÊÓÐʲôºÃ°ì·¨Âð? °²×°OFFICE £¬Ñ¡Ôñ°²×°ACCESS¾Í¿ÉÒÔѽ ¡£ ÒýÓà °²×°OFFICE £¬Ñ¡Ôñ°²×° ......