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

accessµÄ¹«Ê½Ì×ÓÃ


  ÈçºÎʹACCESSµÄAÁУ¨µ¥¼Û£©ÓëBÁУ¨ÊýÁ¿£©×Ô¶¯Ïà³Ë,½á¹û´¢´æÔÚCÁУ¨½ð¶î£©¡£

Ч¹ûÈçÏ£º

          A£¨µ¥¼Û£©        B£¨ÊýÁ¿£©        C£¨½ð¶î£©
    1¡¢    12                6                  72
   
    2¡¢    30                4                  120   

Çë¶®µÄÅóÓÑд³öʵÏֵIJ½Ö裬лл£¡
select µ¥¼Û, ÊýÁ¿, µ¥¼Û * ÊýÁ¿ as ½ð¶î from

update ±í1 set ½ð¶î=µ¥¼Û * ÊýÁ¿

ÒýÓÃ
select µ¥¼Û, ÊýÁ¿, µ¥¼Û * ÊýÁ¿ as ½ð¶î from


ÇëÎÊÕâ¶ÎÓï¾äдÔÚÄÄÀï?´úÂëµÄÄÄÒ»¸öʼþ?

ÒýÓÃ
ÒýÓà 1 Â¥ patrickkong µÄ»Ø¸´:
select µ¥¼Û, ÊýÁ¿, µ¥¼Û * ÊýÁ¿ as ½ð¶î from


ÇëÎÊÕâ¶ÎÓï¾äдÔÚÄÄÀï?´úÂëµÄÄÄÒ»¸öʼþ?

ÎÒ¿´´íÁË£¬ÊÔÊÔ2Â¥µÄ¡£
µ«²»Àí½âÄãΪʲôҪÕâô×ö£¿

ÄãµÄ´úÂëÔÚÄÄÀvb£¿access£¿accessµÄ²éѯÖУ¿

    ÔÚ´úÂëÖмÓÈë  Prices = Val(Text3.Text) * Val(Text4.Text) 
   
    ¾ÍÊǵ±ÎÒÔÚText3ÊäÈëµ¥¼Û£¬ÔÚText4ÖÐÊäÈëÊýÁ¿ºó£¬°´Ï¡°È·ÈϹºÂò¡±°´Å¥ºó£¬×Ô¶¯¼ÆËã³öÏàÓ¦µÄ½ð¶î²¢¼Ç¼ÔÚ±ítb_buyµÄ"Pri


Ïà¹ØÎÊ´ð£º

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

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

ASP+ACCESSÊä³öÎÊÌâ - Web ¿ª·¢ / ASP

ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......

ÈçºÎ½«accessÀïÃæµÄ¸½¼þ±£´æµ½´ÅÅÌÉÏÄØ

Çë´óÏÀÖ¸µã£¬¹òлÁË£¬×îºÃÓдúÂë
ÒªÓõ½ADOX¶ÔÏ󣬲éϰïÖúÎĵµ£¬
http://hyadliujing.blog.163.com/blog/static/4484507420091020969233/?mode=edit

ûÓÐÕÒµ½°¡ ¿´ÁËÄãµÄ²©¿ÍÁË£¬ÎÒÊÇÏ뽫accessÀïÃæµÄ¸½¼þ±£´æ ......

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

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

AccessÑ¡ÖÐij¸ö×ֶλòÕß¶à¸öµ¥Ôª¸ñÖ®ºó¿ÉÒÔ×Ô¶¯ÇóºÍ

Çë´ó¼Ò°ï棬ÎÒÏëÔÚAccess´°ÌåÀïÃæÏÔʾ±íºó£¬Ñ¡Ôñ±íÖеÄij¸ö×ֶΣ¬¾Í¿ÉÒÔ¸ù¾ÝÑ¡ÔñµÄÕâЩµ¥Ôª¸ñÇóºÍ¡¢Ç󯽾ù£¬¾ÍÈçExcelÓÒϽÇ״̬À¸ÄÇÑù£¬ºÜ·½±ãµÄͳ¼ÆÇóºÍÇ󯽾ù£¬Ð»Ð»£¡
Äã¿ÉÒÔÓÃÒ»¸ögridview »òÕ߯äËûʲô¿Ø¼þ ¶ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ