accessµÄ¹«Ê½Ì×ÓÃ
ÈçºÎʹACCESSµÄAÁУ¨µ¥¼Û£©ÓëBÁУ¨ÊýÁ¿£©×Ô¶¯Ïà³Ë,½á¹û´¢´æÔÚCÁУ¨½ð¶î£©¡£
Ч¹ûÈçÏ£º
A£¨µ¥¼Û£© B£¨ÊýÁ¿£© C£¨½ð¶î£©
1¡¢ 12 6 72
2¡¢ 30 4 120
Çë¶®µÄÅóÓÑд³öʵÏֵIJ½Ö裬лл£¡
select µ¥¼Û, ÊýÁ¿, µ¥¼Û * ÊýÁ¿ as ½ð¶î from
update ±í1 set ½ð¶î=µ¥¼Û * ÊýÁ¿
ÇëÎÊÕâ¶ÎÓï¾äдÔÚÄÄÀï?´úÂëµÄÄÄÒ»¸öʼþ?
ÎÒ¿´´íÁË£¬ÊÔÊÔ2Â¥µÄ¡£
µ«²»Àí½âÄãΪʲôҪÕâô×ö£¿
ÄãµÄ´úÂëÔÚÄÄÀvb£¿access£¿accessµÄ²éѯÖУ¿
ÔÚ´úÂëÖмÓÈë Prices = Val(Text3.Text) * Val(Text4.Text)
¾ÍÊǵ±ÎÒÔÚText3ÊäÈëµ¥¼Û£¬ÔÚText4ÖÐÊäÈëÊýÁ¿ºó£¬°´Ï¡°È·ÈϹºÂò¡±°´Å¥ºó£¬×Ô¶¯¼ÆËã³öÏàÓ¦µÄ½ð¶î²¢¼Ç¼ÔÚ±ítb_buyµÄ"Pri
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
Çë´óÏÀÖ¸µã£¬¹òлÁË£¬×îºÃÓдúÂë
ÒªÓõ½ADOX¶ÔÏ󣬲éϰïÖúÎĵµ£¬
http://hyadliujing.blog.163.com/blog/static/4484507420091020969233/?mode=edit
ûÓÐÕÒµ½°¡ ¿´ÁËÄãµÄ²©¿ÍÁË£¬ÎÒÊÇÏ뽫accessÀïÃæµÄ¸½¼þ±£´æ ......
´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......
Çë´ó¼Ò°ï棬ÎÒÏëÔÚAccess´°ÌåÀïÃæÏÔʾ±íºó£¬Ñ¡Ôñ±íÖеÄij¸ö×ֶΣ¬¾Í¿ÉÒÔ¸ù¾ÝÑ¡ÔñµÄÕâЩµ¥Ôª¸ñÇóºÍ¡¢Ç󯽾ù£¬¾ÍÈçExcelÓÒϽÇ״̬À¸ÄÇÑù£¬ºÜ·½±ãµÄͳ¼ÆÇóºÍÇ󯽾ù£¬Ð»Ð»£¡
Äã¿ÉÒÔÓÃÒ»¸ögridview »òÕ߯äËûʲô¿Ø¼þ ¶ ......