C#²Ù×÷Accessʱģºý²éѯBug
ÎÊÌ⣺
·²ÊǶÔAccessÊý¾Ý¿â½øÐÐÄ£ºý²éѯ£¬¼´´ølike¹Ø¼ü×Ö²éѯʱ£¬¾³£ÐԵı¨ÄÚ´æÒç³öÎÊÌ⣡
baidu,googleÁËÖ®ºó£¬¾ù˵ÕâÊÇMS AccessµÄÒ»¸öBug,ÎҶԴ˰ëÐŰëÒÉ¡£ÍøÉÏÌá³öµÄ½â¾ö·½·¨´ó¶àÊÇÕæ¶ÔÈÕÎÄ¡¢º«ÎÄÐÔÖʵĴ洢ÄÚÈݽøÐбàÂëת»»£¬ Ìá½»²éѯÌõ¼þºÍ²éѯÍêÁËÖ®ºó£¬ÔÙת»»¹ýÀ´¡£ºÜ²»ÐÒµÄÊÇ£¬ÎҵĴ洢ÄÚÈݲ»ÊÇÈÕÎÄ¡¢º«ÎÄ£¬ÊÇÖÐÎļòÌ壬µ«Í¬Ñù¾³£ÐԵı¨ÄÚ´æÒç³ö£¬·Ç³£·³ÄÕ£¬ÌýÎÅCSDN¸ßÊÖÈçÔÆ£¬ÌØÀ´CSDNѰÇó°ïÖú£¬²»Éõ¸Ð¼¤£¡
±¸×¢£ºSQLÓï¾ä±¾Éí¾ø¶ÔûÓÐÎÊÌ⣡
¹Ø×¢¡£ºÜÉÙÓÃACCESS¡£Ã»Åöµ½¹ý
¸Ðлxray2005°ï¶¥....
¿ÉÄÜ
ÔõôÎÒ¾ÍûÓÐÓöµ½¹ýÄØ
AccessÊý¾Ý¿âÒ²Óùý,ûʲôÎÊÌâŶ!!
¾Í¾õµÃsqlÓï¾äºÍsql serverÓï¾äÓеãÇø±ð!
AccessÖÐlike µÄͨÅä·ûÊÇ*,¶øsql serverÖÐlikeÊÇ%,
»¹ÓÐÈÕÆÚÒ²ÓÐÇø±ð!
ÖÁÓÚ"ÄÚ´æÒç³ö"ûÓöµ½¹ý!!
ÊÔÊÔ×îаæµÄACCESS »òÕßÊÇÄãµÄACCESSÒýÇæ±È½ÏÀϵÄÔÒò
²»¹ýËµÕæµÄ ÎÒ»¹Ã»Óöµ½¹ýACCESSÄÚ´æÒç³öµÄÇé¿ö
¶¥Õâ¸ö~
bd
¸÷λ¥ÉϵÄÅóÓÑËùÌá³öµÄÒâ¼ûÎһ᳢ÊԺ͵÷ÊÔ£¬·Ç³£¸Ðл£¡
ÓиöÎÊÌâÄãҪעÒâÏ£º
ÎÒ²»ÖªµÀÄãµÄÊý¾ÝÊÇ×Ô¼ºÐ´½øÈ¥µÄ »¹Êǵ¼Èëtxt£¬excelµÈ
ÎÒÔÚµ¼ÈëtxtÖÐÓöµ½Ò»¸öÎÊÌ⣺¾ÍÊÇ×Ö·û¼¯ÎÊÌâ
ÓÉÓÚaccessĬÈϵÄ×Ö·û¼¯ ²»Ö§³ÖËùÓеÄ×
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
21cnµÄÓÊÏ䣬ÔÚoutlookÅäÖúó¿ÉÒÔÕý³£ÊÕ·¢Óʼþ£¬¿ÉÊÇÎÒдÔÚC#ÖоͲ»ÐУ¬»»³ÉÆäËüÓÊÏ䣬163ºÜÔç×¢²áµÄ¡£¿ÉÒÔ·¢ËÍ¡£²éÁ˺ܾã¬Ã»ÓÐÕÒµ½ÔÒò£¬Çë¸ßÊÖ°ïæ½â´ð¡£¡£¡£Ð¡µÜ£¬Ð»ÁË¡£¡£´úÂëÈçÏ£º
private void SendMail ......
Çë´óÏÀÖ¸µã£¬¹òлÁË£¬×îºÃÓдúÂë
ÒªÓõ½ADOX¶ÔÏ󣬲éϰïÖúÎĵµ£¬
http://hyadliujing.blog.163.com/blog/static/4484507420091020969233/?mode=edit
ûÓÐÕÒµ½°¡ ¿´ÁËÄãµÄ²©¿ÍÁË£¬ÎÒÊÇÏ뽫accessÀïÃæµÄ¸½¼þ±£´æ ......
dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
<param name="formBean" value="prisonerForm"/>
< ......