Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : access

asp Á¬½Ó access ³ö´í - Web ¿ª·¢ / ASP

´íÎóÐÅÏ¢£º
¡°
ACCESSÊý¾Ý¿âÁ¬½Ó³ö´í£¬Çë¼ì²éÁ¬½Ó×Ö´®¡£
Microsoft JET Database Engine (-2147467259)
¡±
ÎÒÊÇÔÚÍøÉÏϵÄÒ»¸öÍøÕ¾ asp+access
ÎÒÔÚ±¾µØÓÃiis²¿ÊðµÄʱºò
ÓеĻú×Ó¿ÉÒÔ·ÃÎÊ
ÓеĻú×Ӿͱ¨Õâ¸ö´íÎóÐÅÏ¢
ËùÓлú×Ó¶¼ÊÇXPµÄϵͳ
ÄÄλ֪µÀʲôÎÊÌâ
Ö¸µ¼ÎÒÏÂ

Á¬½Ó×Ö·û´®ºÍsqlÌù³öÀ´¿´¿´£¿

дÈëȨÏÞ ......

access updateÓï¾ä

sql:='update dzhyb set jdbzw=1 and jdkssj='''+sheet2shijian+''' where chehao='''+trim(edit1.Text)+''' and ((zhanneisj is null) or (zhanneisj=''''))';
  ³ö´í£¬Èç¹ûÔ­À´ÈÕÆÚʱ¼äÄÇÀïÓÐÖµ£¬¾Íµ¯´íÎó£¬Ëµ±ê×¼±í´ïʽÖÐÊý¾ÝÀàÐͲ»Æ¥Åä¡£Èç¹ûÔ­À´ÄÇÀïΪ¿Õ£¬ÍùÀïÐÞ¸ÄÖµ£¬¾Íʲô·´Ó¦Ã»ÓУ¬ÄÚÈÝҲûÓм½øÈ¥¡£
......

accessÊý¾Ý¿â ʵÏÖ ±íÖÐ ÊýÁ¿*µ¥¼Û=½ð¶î

ÓÐÒ»¸ö±íÖÐÓкܶà×ֶΠÔõôʵÏÖÈñíÖÐµÄ ½ð¶î=ÊýÁ¿*µ¥¼Û£¿£¨×¢Òâ £ºÈý¸ö×Ö¶ÎÈ«ÔÙͬһ¸ö±íÖÐ £¬²»ÒªËµÊ²Ã´²éѯ³öÀ´Éú³ÉÁíÒ»¸ö±í¡£¿ÉÒԵĻ°ÇëдÏêϸ²½Öè лл £©
ºÇ £¬²éѯµÄʱºò²»ÓøüÉú³ÉÒ»¸ö±í°¡£¬Ö±½Ó¾Í ÊýÁ¿*µ¥¼Û±íʾ¾ÍºÃÁËÂï

select ÊýÁ¿,µ¥¼Û, ÊýÁ¿*µ¥¼Û

ллÄãÃǵĻش𠣬¿ÉÄÜÎÒû˵Ã÷°×ÎÒµÄÒâ˼ £¬ÎÒÊÇÏ ......

accessµÄÀàÄ£¿é£¿

ÔÚvbaÀﶨÒåÁËÒ»¸öÀàÄ£¿é£¬³õʼ»¯¼°µ÷Óö¼Õý³£
×îºó ¡°Set m_´°Ìå = Nothing ¡± ¡®m_´°Ìå ÊÇÀàµÄʵÀý
Private Sub Class_terminate() Õâ¸öÏú»Ùº¯Êý²¢Ã»Óб»µ÷Óã¿Ê²Ã´Ô­Òò°¡£¿

ÄãµÄÀàÊÇÈçºÎ¶¨ÒåµÄ£¿

ÎÒ·ÖÎö¿ÉÄÜÊÇÀà±¾ÉíÉú³ÉµÄ¶ÔÏóûÓÐÊÍ·ÅÔì³ÉµÄ
ÔÚÎÒµÄÀàÄ£¿éÖУº
¶¨ÒåÓÐÀàµÄ¹«¹²±äÁ¿µÄ¡°dc_1¡±£¬×÷ΪÀàʵÀýºÍÍâ ......

c#Á´½ÓACCESSµÄÁ´½Ó×Ö´®Ôõôд£¿

ÈçÌ⣬ÐèÒªÁ¬½ÓACCESSÊý¾Ý¿â£¬Ð»Ð»
C# code:

//Á¬½Ó×Ö·û´®
private static string connString = "Provider=Microsoft.Jet.OLEDB.4.0;;Data Source=DataBase.mdb";//DataBase.mdbÊý¾Ý¿âÎļþÃû

http://www.connectionstrings.com


DataBase.mdbÊÇÊý¾Ý¿âµÄÎļþÃû£¬µ«ÊÇÎÒÏëµÃÖªµÀÊý¾Ý¿âÎļþµÄ´æ·Å·¾¶² ......

C# ·ÃÎÊAccessÊý¾Ý¿âµÄÎÊÌâ..

ÔÚÏòÒ»¸ö±í(Account)²åÈëÊý¾Ýʱ,Ìáʾ²åÈë³É¹¦,µ«´ò¿ªÊý¾Ý¿âʱÀïÃæȴûÓвåÈëµÄ¼Ç¼...´úÂëÈçÏÂ:
  readonly string constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Database.mdb;Jet OLEDB:Database Password=layerworkshop";
  /// <summary>
  /// ´´½ ......
×ܼǼÊý:990; ×ÜÒ³Êý:165; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [13] [14] [15] [16] 17 [18] [19] [20] [21] [22]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ