´íÎóÐÅÏ¢£º
¡°
ACCESSÊý¾Ý¿âÁ¬½Ó³ö´í£¬Çë¼ì²éÁ¬½Ó×Ö´®¡£
Microsoft JET Database Engine (-2147467259)
¡±
ÎÒÊÇÔÚÍøÉÏϵÄÒ»¸öÍøÕ¾ asp+access
ÎÒÔÚ±¾µØÓÃiis²¿ÊðµÄʱºò
ÓеĻú×Ó¿ÉÒÔ·ÃÎÊ
ÓеĻú×Ӿͱ¨Õâ¸ö´íÎóÐÅÏ¢
ËùÓлú×Ó¶¼ÊÇXPµÄϵͳ
ÄÄλ֪µÀʲôÎÊÌâ
Ö¸µ¼ÎÒÏÂ
Á¬½Ó×Ö·û´®ºÍsqlÌù³öÀ´¿´¿´£¿
дÈëȨÏÞ ......
sql:='update dzhyb set jdbzw=1 and jdkssj='''+sheet2shijian+''' where chehao='''+trim(edit1.Text)+''' and ((zhanneisj is null) or (zhanneisj=''''))';
³ö´í£¬Èç¹ûÔÀ´ÈÕÆÚʱ¼äÄÇÀïÓÐÖµ£¬¾Íµ¯´íÎó£¬Ëµ±ê×¼±í´ïʽÖÐÊý¾ÝÀàÐͲ»Æ¥Åä¡£Èç¹ûÔÀ´ÄÇÀïΪ¿Õ£¬ÍùÀïÐÞ¸ÄÖµ£¬¾Íʲô·´Ó¦Ã»ÓУ¬ÄÚÈÝҲûÓм½øÈ¥¡£
......
ÓÐÒ»¸ö±íÖÐÓкܶà×ֶΠÔõôʵÏÖÈñíÖÐµÄ ½ð¶î=ÊýÁ¿*µ¥¼Û£¿£¨×¢Òâ £ºÈý¸ö×Ö¶ÎÈ«ÔÙͬһ¸ö±íÖÐ £¬²»ÒªËµÊ²Ã´²éѯ³öÀ´Éú³ÉÁíÒ»¸ö±í¡£¿ÉÒԵĻ°ÇëдÏêϸ²½Öè лл £©
ºÇ £¬²éѯµÄʱºò²»ÓøüÉú³ÉÒ»¸ö±í°¡£¬Ö±½Ó¾Í ÊýÁ¿*µ¥¼Û±íʾ¾ÍºÃÁËÂï
select ÊýÁ¿,µ¥¼Û, ÊýÁ¿*µ¥¼Û
ллÄãÃǵĻش𠣬¿ÉÄÜÎÒû˵Ã÷°×ÎÒµÄÒâ˼ £¬ÎÒÊÇÏ ......
ÔÚvbaÀﶨÒåÁËÒ»¸öÀàÄ£¿é£¬³õʼ»¯¼°µ÷Óö¼Õý³£
×îºó ¡°Set m_´°Ìå = Nothing ¡± ¡®m_´°Ìå ÊÇÀàµÄʵÀý
Private Sub Class_terminate() Õâ¸öÏú»Ùº¯Êý²¢Ã»Óб»µ÷Óã¿Ê²Ã´ÔÒò°¡£¿
ÄãµÄÀàÊÇÈçºÎ¶¨ÒåµÄ£¿
ÎÒ·ÖÎö¿ÉÄÜÊÇÀà±¾ÉíÉú³ÉµÄ¶ÔÏóûÓÐÊÍ·ÅÔì³ÉµÄ
ÔÚÎÒµÄÀàÄ£¿éÖУº
¶¨ÒåÓÐÀàµÄ¹«¹²±äÁ¿µÄ¡°dc_1¡±£¬×÷ΪÀàʵÀýºÍÍâ ......
ÈçÌ⣬ÐèÒªÁ¬½Ó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ÊÇÊý¾Ý¿âµÄÎļþÃû£¬µ«ÊÇÎÒÏëµÃÖªµÀÊý¾Ý¿âÎļþµÄ´æ·Å·¾¶² ......
ÔÚÏòÒ»¸ö±í(Account)²åÈëÊý¾Ýʱ,Ìáʾ²åÈë³É¹¦,µ«´ò¿ªÊý¾Ý¿âʱÀïÃæȴûÓвåÈëµÄ¼Ç¼...´úÂëÈçÏÂ:
readonly string constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Database.mdb;Jet OLEDB:Database Password=layerworkshop";
/// <summary>
/// ´´½ ......