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

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.ȨÏÞ²»×ã ÒòΪÎÒÃǵĻúÆ÷ ¶¼¼ÓÈëÁËÓò µ«µÇ½µÄϵͳÕË»§Ò²¼ÓÈëµ½ÁËȨÏÞÖÐ ¿É


Ïà¹ØÎÊ´ð£º

asp¸úAccessÊý¾ÝÁ¬½ÓÎÊÌâ¡£

IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC)

'===========================================================================
SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû
S ......

accessÌí¼ÓÊý¾Ý

sql="insert  into  users(username,password) values('aa','bbb')" 
conn.execute sql
²¹³ä£ºÔõô¼Ó²»½øÈ¥ÄØ£¿


ÒòΪaa,bbbÊÇÄã×Ô¼º¶¨ÒåµÄ±äÁ¿£¬Ëùд³ÉÕâ ......

Access²éÕÒÖØ¸´ÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......

ADO.NET²Ù×÷AccessµÄÎÊÌâ

C# code:

public override int Update(Table model, DbTransaction dbtran)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Tabl ......

¼±¼±£¡£¡¹ØÓÚ²éѯACCESSÒ»¸ö×ֶεÄËùÓмǼÎÊÌâ

Çë½Ì¸ßÊÖ2¸öÎÊÌ⣺
1¡¢¹ØÓÚ²éѯACCESSÒ»¸ö×ֶεÄËùÓмǼÎÊÌ⣻ÔõôÏÂÃæ´úÂëÎÞ·¨´ò¿ªÊý¾Ý¿âѽ£¿
2¡¢ÏÂÃæµÄ´úÂë¿ÉÒÔ·ÃÎÊ¡°¹ú±êÂ롱×Ö¶ÎÖеÄËùÓмǼֵÂð£¿


¼±¼±£¡£¡£¡£¡£¡£¡£¡£¡

vbÓïÑÔ´úÂëÈ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ