winform ACCESS δָ¶¨µÄ´íÎó 100·Ö
winformÓ¦ÓóÌÐò Á¬½Ó×Ö·û´® Provider=Microsoft.Jet.OLEDB.4.0;Data Source=dbpath dbpathΪ¾ø¶Ô·¾¶ Õâ¸ö·¾¶ÊÇûÓÐÈκÎÎÊÌâµÄ ÔÚÖ´Ðе½connection.open()ʱ ±¨System.Data.OleDb.OleDbException: δָ¶¨µÄ´íÎó ¾¹ýËÑË÷ºó ·¢ÏֺܶàÀàËÆµÄ´íÎó¶¼ÊÇASP.NETµÄ ·¢ÏÖÒÔϽâ¾ö·½·¨ 1.ÐÞ¸ÄTEMPĿ¼ȨÏÞ£¨ÒòΪÊÇwinform³ÌÐò ËùÒÔÓ¦¸ÃºÍÕâ¸öÎÞ¹Ø Î´³¢ÊÔ£© 2.ѹËõÐÞ¸´Êý¾Ý¿â(ÎÞЧ) 3.ÖØÐÂ×¢²áACCESSÇý¶¯£¨ÎÞЧ£© Êý¾Ý¿âÊǵ¥»úʹÓà ²»´æÔÚ²¢·¢ÎÊÌâ ÇÒͬÑù´úÂë ÔÚÆäËû»úÆ÷ÉÏ¿ÉÒÔÔËÐÐ ¿ÉÄܾÍÓÐ1-2̨»úÆ÷ÓÐÕâÑùµÄÎÊÌâ ÇëÎÊ´ó¼ÒÓöµ½¹ýÕâÑùµÄÎÊÌâÂð ÓÐûÓÐʲô°ì·¨¿ÉÒÔ½â¾ö£¿
Server.MapPath()²é¿´Â·¾¶£¿ ÓÐÁ´½Ó³É¹¦¹ýÂ𣿠»ØÂ¥ÉÏ ÊÇwinform ²»ÊÇasp.net ͨ¹ýApplication.StartupPath+""ÉèÖõØÖ· ¹À¼ÆÊÇ·¾¶£¬Êý¾Ý¿âµÄÃû×Ö£¬»¹ÓÐÊÇ·ñÉèÖÃÁËÃÜÂ룬Êý¾Ý¿âÊÇ·ñÒѱ»ÆäËû³ÌÐò´ò¿ªµÈµÈÓйØÏµ¡£¡£¡£ÒýÓà ¹À¼ÆÊÇ·¾¶£¬Êý¾Ý¿âµÄÃû×Ö£¬»¹ÓÐÊÇ·ñÉèÖÃÁËÃÜÂ룬Êý¾Ý¿âÊÇ·ñÒѱ»ÆäËû³ÌÐò´ò¿ªµÈµÈÓйØÏµ¡£¡£¡£ ¾ßÌåµÄÔÒò»¹Õæ²»ÊÇÒÔÏ ¾ÍÄÜ¿´³öÀ´µÄ ÎÒ²âÊÔÁËһϠ·¾¶ÊǾø¶ÔûÓÐÎÊÌâµÄ ÒòΪÔÚ±¨´íµÄ»úÆ÷ÉÏ °Ñ·¾¶Êä³öÁË Í¨¹ýÊä³ö·¾¶ ÊÇ¿ÉÒÔ´ò¿ªACCESSµÄ Êý¾Ý¿âûÓÐÃÜÂë ҲûÓб»ÆäËû³ÌÐò´ò¿ª »ù±¾ÉÏ¿ÉÒÔÅųýACCESSµÄÎÊÌâ ÒòÎªÖØÐÂ×¢²áÁËÇý¶¯ºó Ìáʾע²á³É¹¦ È»ºó°ÑûÓб¨´í»úÆ÷ÉϵÄACCESS¿½±´¹ýÀ´ ¸²¸ÇÔACCESSÎļþ µ«ÒÀ¾É±¨´í ÏÖ»³ÒÉÊÇ£º 1.ȨÏÞ²»×ã ÒòΪÎÒÃǵĻúÆ÷ ¶¼¼ÓÈëÁËÓò µ«µÇ½µÄϵͳÕË»§Ò²¼ÓÈëµ½ÁËȨÏÞÖÐ ¿É
Ïà¹ØÎÊ´ð£º
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡ ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖà sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£ ÊÇ ......
<?php include("adodb/adodb.inc.php"); $db = &NewADOConnection("access"); $access = realpath("Data.mdb"); $dsn = "Provider=Microsoft.J ......
ÎÊÌâÈçÏ£º ÓòéѯÓï¾ä select * from tab where fil like 'CK090902'ÄܲéÕÒ³öÒ»Ìõ¼Ç¼²¢ÏÔʾ³öÀ´ ¸ÄΪ select * from tab where fil = 'CK090902' ¾Í²»ÄܲéÕÒµ½£¬Ò²ÏÔʾ²»³öÀ´ ......
sql="insert into users(username,password) values('aa','bbb')" conn.execute sql ²¹³ä£ºÔõô¼Ó²»½øÈ¥ÄØ£¿ ÒòΪaa,bbbÊÇÄã×Ô¼º¶¨ÒåµÄ±äÁ¿£¬Ëùд³ÉÕâ ......
×î½ü×¼±¸Îª¹«Ë¾ÍøÕ¾ÓÃVB×ö¸ö²úƷչʾÉú³É£¬Éú³É²¿·Ö»ù±¾Ã»ÎÊÌ⣬ ÎÊÌâ³öÏÖÔÚ²éѯ²¿·Ö£¬Ê¹ÓÃÁËMSHFelxGrid(DATAGrid²»ÄÜÂú×ã²Ù×÷ÐèÇó)£¬±¾À´ÒÔΪÊÕ¹¤ÁË£¬×òÌìÔٴβâÊÔµÄʱºò·¢ÏÖÁËÒÔÏÂÎÊÌâ µ±Êý¾Ý¿â×Ö¶ÎÎ ......