Access ´°ÌåÖÐÐмǼ ±ä»¯ ʱ´¥·¢ ʼþÊÇʲô
ÈçÌâÄ¿
Access ´°ÌåÖÐÐмǼ ±ä»¯ ʱ´¥·¢ ʼþÊÇʲô°¡
´°ÌåÉÏÓиöÊý¾Ý±í1µÄ ×Ö¶ÎA ×Ö¶ÎB ×Ö¶ÎCµÄ ×Ö¶ÎDÊÇCombo1 ÏÔʾ
×Ö¶ÎDµÄÐÐÊý¾ÝÊÇÒ»¸öQuery ,µ«ÊÇºÍ µ±Ç°ÐеÄ×Ö¶ÎAÏà¹Ø
×Ö¶ÎDµÄÊý¾Ýÿ´ÎÀ´Ô´¶¼ÐèҪˢÐÂһϣ¬µ«ÊÇÎÒдÔÚ´°ÌåµÄ ¸üкó ʼþÀ
×Ö¶ÎDµÄÊý¾Ý²»Ë¢Ð£¬ÎÒдÔÚÒ»¸ö°´Å¥ÀïµÄµÄˢРCombo1.Requery
¾Í¿ÉÒÔ £¬²»ÖªµÀΪɶ
×Ô¼º¸ã¶¨ ÁË £¬ Ö»ÒªÔÚCombo2»ñµÃ½¹µãµÄʼþµØ·½Ð´Ò»¾äCombo2.Requery
¶àл ACMain ¹ØÐÄ
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
DbgridÁ¬½Óaccess ÏÔʾÊý¾ÝʱÍ϶¯¹ö¶¯ÌõËÀ»ú£¿Ôõô½â¾ö°¡£¿
»úÆ÷Ì«²îÁ˰ɣ¿
ÊDz»ÊÇÄãÊý¾ÝÁ¿Ì«´óÁ˰¡
ÄãÊý¾ÝÉÙһЩ¿´¿´»¹ËÀ»úÂð£¿
Êý¾ÝºÜÉÙ°¡ ¾ÍÒ»Ò³¡£
ÎÒÔÚBCB6ÏÂ×ö¹ý²»ÉÙ DBGRID+ACCESS £¬´ÓÀ´Ã»ÓÐÓöµ½ ......
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
ÎÊÌâÊÇÕâÑùµÄ,ÏÖÔÚÓÐÒ»¸ö¹¤×ʱí,ÊÇEXCELµÄ,ÎÒÒª°ÑËüµ¼ÈëACCESS,ÒòΪ Òª²éѯÿ¸öÈ˵Ť×Ê,¸ù¾Ý²»Í¬µÄ±àºÅ¿ÉÒÔ²éѯµ½Ïà¶ÔµÄÈË,
ÓÃASP Ôõô½«EXCELµ¼Èëµ½ACCESS,¶øÇÒÿÔ¶¼Óв»Í¬µÄ±í,
ÒýÓÃ
Æäʵ¾ÍÊǰÑEXCELµ±³ÉÊý ......