access δָ¶¨´íÎó
access δָ¶¨´íÎó
·Åµ½IISÉÏˢм¸´Î¾Í»á³öÏÖ
ʹÓö¯ÈíµÄDbHelperOleDb.csÀà·ÃÎÊDatabase.accdbÊý¾Ý¿â
ˢм¸´Î¾Í»á³öÏÖ???
»¹ÓÐÕý³£µÄʱºò£¿
ÊÇ·ñ´ò¿ªÁËÊý¾Ý¿â£¬ÓÃÍêδ¶Ï¿ª£¨¹Ø±Õ£©Á¬½Ó£¿
ÓÑÇé°ï¶¥
×Ô¼º½â¾öÁË£¬ÊÇExecuteReaderÕâ¸öÔĶÁÆ÷£¬ËûÔÚUSINGÖв¢Ã»Óйرգ¬ÔÚËû¶ÁÈ¡µÄʱºóÒª±£³ÖÁ¬½Ó£¬¿ÉÊÇËû¶ÁÈ¡ºóUSING²¢Ã»Óм°Ê±µÄ»ØÊÕ£¬ËùÒÔ²ÅÕâÑù£¬ÎÒ×Ô¼º¸ø¹ØÁËһϾͺÃÁË
Óö¯ÈíµÄÀà¿ÉҪСÐÄÁË
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤?
ÄãÊÇÔõÑù¸³ÖµµÄ£¿
²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û
ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......
Çë´óÏÀÖ¸µã£¬¹òлÁË£¬×îºÃÓдúÂë
ÒªÓõ½ADOX¶ÔÏ󣬲éϰïÖúÎĵµ£¬
http://hyadliujing.blog.163.com/blog/static/4484507420091020969233/?mode=edit
ûÓÐÕÒµ½°¡ ¿´ÁËÄãµÄ²©¿ÍÁË£¬ÎÒÊÇÏ뽫accessÀïÃæµÄ¸½¼þ±£´æ ......
±í½á¹¹:
table1
Ö¤¼þºÅ ʱ¼ä
X31 2010-01-11
3BC 2010-02-03
3AD 2010-02-03
F23 2010-02-09
......
ÏÖÔÚҪͳ¼ÆÒ»¸öʱ¼ä¶ÎÈç 2010-01-09 µ½ 2010-02-09¼äµÄÊý¾Ý,
ÆÚ´ý½ ......