Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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.ȨÏÞ²»×ã ÒòΪÎÒÃǵĻúÆ÷ ¶¼¼ÓÈëÁËÓò µ«µÇ½µÄϵͳÕË»§Ò²¼ÓÈëµ½ÁËȨÏÞÖÐ ¿É


Ïà¹ØÎÊ´ð£º

access ÖÐÖ´ÐÐsqlÓï¾äupdate²»³É¹¦£¬ÇóÖú£¡£¡£¡

access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôԭÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ

sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£

ÊÇ ......

ACCESSÊý¾Ý¿âÓëVB¿ª·¢µÄÈí¼þ½øÐл¥Á¬ÍøÁ¬½Ó

±¾À´ÎÒÊÇÓÃACCESS+VB½¨Á¢Ò»¸öÈí¼þ£¨¾ÖÓòÍø£©£¬ÏÖÔÚÓÉÓڰ칫µØµãÓб䶯£¬Ïà»»³ÉINTERNATµÄ£¬ÓÐûÓа취½â¾ö£¬

ÏóÕâÑùµÄÇé¿ö£¬Èç¹ûÊǹãÓòÍø£¬×îºÃ¸Ä³É£ºB\SµÄ
Èç¹ûÊǾÖÓòÍøµÄ£¬×îºÃ¸Ä³É£ºC\SµÄ
http://downlo ......

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

C# code:

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

¹ØÓÚaccessÊÇ·ñÓÐͳ¼Æ¹¦ÄÜ

  ÎÒ½¨Á¢2¸ö±í,±ÈÈçtable a    table b
  ¼ÙÈçÎÒtable a µÄÖµµÃÊÇÍøÒ³Ìá½»ÊäÈë½øÀ´..
  Äܲ»ÄÜÔÚaccessÓмÆË㹦ÄÜ,¼ÆËã½á¹û¸³Óètable b
 

  Èç:  ta ......

MSHFelxGrid Óë ACCESS MEMOÀàÐÍ×ֶεÄÒÉÎÊ

×î½ü×¼±¸Îª¹«Ë¾ÍøÕ¾ÓÃVB×ö¸ö²úƷչʾÉú³É£¬Éú³É²¿·Ö»ù±¾Ã»ÎÊÌ⣬
ÎÊÌâ³öÏÖÔÚ²éѯ²¿·Ö£¬Ê¹ÓÃÁËMSHFelxGrid(DATAGrid²»ÄÜÂú×ã²Ù×÷ÐèÇó)£¬±¾À´ÒÔΪÊÕ¹¤ÁË£¬×òÌìÔٴβâÊÔµÄʱºò·¢ÏÖÁËÒÔÏÂÎÊÌâ

µ±Êý¾Ý¿â×Ö¶ÎÎ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ