ÎÒÓÐÒ»¸öVBµÄACTIVEX¿Ø¼þ·ÅÔڣףţÂÉÏÓã¬
¿Ø¼þµÄ¹¦ÄÜÊÇͨ¹ý£Ò£Ó£²£³£²ÓëijÒDZíÏàÁ¬£¬¿ÉÒÔʵʱ¶Á³öÒDZíµÄÊýÖµ£¬ÔÚÆäËû»úÆ÷ÉÏÔËÐÐÕý³££¬
¿ÉÊÇÏÖÔÚÓÐһ̨»úÆ÷ÓÃÁËÕâ¸ö¿Ø¼þºó£¬¿ÉÒÔÕý³£¶Á³öÒDZíµÄÊý£¬
µ«ÊǣãУÕÂíÉÏ£±£°£°£¥£¨ÆäËü»úÆ÷ÔÚ£´£°£¥££µ£°£¥Ö®¼ä£©£¬¸ãµÄµçÄÔ×ÜÊÇËÀ»ú£¬
ÕâÊÇÔõô»ØÊ£ ......
ËÓÐVBµ÷ÓÃEXCELµÄÊ飬ÎÒ½«Ò»¸öEXCELÎļþÐ޸ĺó£¬ÎÒÏë±£´æ£¬ÔõÑùд´úÂë
ÎÒ°´¹Â¶À½£µÄ·½·¨È¥×ö£¬µ«ÊÇOFFICE»á±¨´í£¬³ÌÐò×ß²»ÏÂÈ¥
´úÂ룿±¨Ê²Ã´´í£¿
´úÂë
лл¡£µ«ÎÒÒ»ÔËÐУ¬OFFICE¾Í±¨´í
......
ÔÚVBÖУ¬ÍùformÖÐÌí¼Ó¿Ø¼þºó£¬µ±¿Ø¼þ´óС»òλÖ÷¢Éú±ä»¯Ê±£¬ÎªºÎÔڿؼþÊôÐÔÀ¸ÖеÄcaptionÊôÐÔ±äΪ"c" Çë¸ßÊÖ°ïÖú½â¾ö
²»ÊǵÄ
²»ÖªµÀʲôÇé¿öϲúÉúµÄ£¬Èç¹ûÅųýÈËΪÒòËØ....
²»Çå³þ£¬Ã»ÓÐÓöµ½¹ý
ÒýÓÃ
ÔÚVBÖУ¬ÍùformÖÐÌí¼Ó¿Ø¼þºó£¬µ±¿Ø¼þ´óС»òλÖ÷¢Éú±ä»¯Ê±£¬ÎªºÎÔڿؼþÊôÐÔÀ¸ÖÐ ......
ÔÂн¼ÆË㣺¾ÀíÄù̶¨ÔÂн8000Ôª£»¼¼ÊõÔ±°´Ã¿Ð¡Ê±100ÔªÁìÈ¡ÔÂн£»ÍÆÏúÔ±µÄÔÂн°´¸ÃÍÆÏúÔ±µ±ÔÂÏúÊÛ¶îµÄ4%Ìá³É£»ÏúÊÛ¾Àí¼ÈÄù̶¨ÔÂнҲÁìÈ¡ÏúÊÛÌá³É£¬¹Ì¶¨ÔÂнΪ5000Ôª£¬ÏúÊÛÌá³ÉΪËù¹ÜϽ²¿Ãŵ±ÔÂÏúÊÛ×ܶîµÄ5%¡£
Òª¿´ÄãµÄÊý¾Ý¿âÔõôÉè¼Æ£¡´úÂëÒª»ùÓÚÊý¾Ý¿âÉè¼ÆµÄ
°ï¶¥
ÏÈÉè¼ÆºÃÊý¾Ý¿â£¬Ò»°ãÓ¦·ÖΪӦ·¢ÏîºÍÓ¦¿ÛÏӦ· ......
ÎÒÔÚ¿´±ðÈ˵ÄÒ»¸öÏîÄ¿£¬ ËûµÄÊý¾Ý¿âÊÇÓÃACCESSµÄ£¬ µ±ÎÒ´ò¿ªMDBÎļþºó£¬ µã»÷²éÑ¯Ò³Ãæ£¬ ·¢ÏÖÓкܶà²éѯÊÓͼ£¬ ÇëÎÊÕâЩ²éѯÊÓͼÓÐʲôÓô¦Â𣬠ÎÒÔÚ³ÌÐòÀï²»ÊÇÒ»Ñù¿ÉÒÔÓÃSQLÓï¾ä×öÂ𣬠ΪʲôҪ×öºÜ¶à²éѯÊÓÍ¼ÄØ£¬ ÓÐʲôºÃ´¦£¬ ÔõôÔÚ³ÌÐòÖÐÓÃÕâЩÊÓÍ¼ÄØ£¿
Õâ¸öÎÊÌâÊôÓÚ»ù´¡¸ÅÄî¡£¡¡²»Á˽âÄãĿǰµÄˮƽ£¬ËùÒÔ²»ÖªµÀ´ÓÄÄÒ ......
VB.NET code:
Dim strSql As New StringBuilder()
strSql.Append("select * from ¶¨µ¥ where 1=1 ")
strSql.Append(" and ʱ¼ä >= @¿ªÊ¼Ê±¼ä and ʱ¼ä <= @½áÊøÊ±¼ä and Õ˺Å=@Õ˺Å")
Dim parameters As OleDbParameter() = {New OleDbPa ......