Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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

MFCÁ¬½ÓACCESS ³ö´í

Âé·³¸÷λ°ïæ¿´¿´°¡
´úÂëÈçÏ£º
CoInitialize(NULL);
  _ConnectionPtr pConn(__uuidof(Connection)); 
_RecordsetPtr pRst(__uuidof(Recordset));
pConn->ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\access\db1.mdb;Persist Security Info=False";
pConn-&g ......

ÔõÑù´ò¿ªÊý¾Ý¿âΪaccessµÄϵͳ£¿

ÓÃC#×öµÄϵͳ£¬Êý¾Ý¿âΪaccess2003£¬ÔõÑù´ò¿ªÏµÍ³£¿accessÊý¾Ý¿âÔõÑù²Ù×÷.mdbÎļþ£¿
Óësql server²Ù×÷Ò»ÑùÂð£¿ÊDz»ÊÇÒ²ÐèÒª¸½¼ÓÊý¾Ý¿â£¿

Çë¼òҪ˵Ã÷һϲ½Öè ллÁË
²¹³äһϣº
ÎÒÓõĿª·¢¹¤¾ßÊÇvs.net 2003

Ó¦¸ÃÓëSQLÀàËÆ,²»¹ýÁ¬½Ó×Ö·û´®ÓÐЩ²»Í¬

ÐèÒª½«.mdbÎļþ¸½¼Óµ½access ÖÐÂð£¿


ÒýÓÃ
Ð ......

ÇóÖúACCESSÓÃLIKEÎÊÌâ

ÎÒµÄÓï¾äÊÇselect * from Tab where ID like '*" & txt.text & "*' ʲô¶¼²é²»µ½£¬µ«ÊÇÎÒÊý¾Ý¿â±íÀï¿Ï¶¨ÊÇÓÐÊý¾ÝµÄ£¬²»¼ÓWHEREÌõ¼þ¾ÍÓмǼ¼¯ Óà % Õâ¸öÒ²²é²»µ½£¬Çë´óÏÀ°ïæ ¿´Ò»Ï ÎÒÓõÄÊÇVB+ACCESS
DBCN = "Provider=microsoft.jet.oledb.4.0;data source=" & App.Path &a ......

c#²éѯaccessÊý¾Ý¿â´úÂë

ÇëÎÊÔõÑùÔÚc#ÏîÄ¿ÖвéѯaccessÊý¾Ý¿âÖеÄÊý¾Ý£¬´úÂëÊÇÔõÑù°¡£¿£¿Çë¸ßÊÖÖ¸µã
oledbconnection

ͬ¥ÉÏ

²Î¿¼ÒÔÏ´úÂë,¿´ÄÜ·ñ½â¾öµ½ÄãµÄÎÊÌâ

string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";
strConnection+=@"Data Source=MapPath("Êý¾Ý¿â.mdb");//ÕâÀïÊÇÏà¶Ô·¾¶
......

.net²Ù×÷access³ö´í´ó¼Ò°ï¿´Ò»ÏÂ

ÎÒÓõÄÊǶ¯ÍøµÄÁ¬½Ó¿â µÚÒ»´Î´ò¿ªÃ»ÎÊÌâ µ«Êǵ±¶àˢм¸´Îºó³ö´í
C# code:

δָ¶¨µÄ´íÎó
˵Ã÷: Ö´Ðе±Ç° Web ÇëÇóÆÚ¼ä£¬³öÏÖδ´¦ÀíµÄÒì³£¡£Çë¼ì²é¶ÑÕ»¸ú×ÙÐÅÏ¢£¬ÒÔÁ˽âÓйظôíÎóÒÔ¼°´úÂëÖе¼Ö´íÎóµÄ³ö´¦µÄÏêϸÐÅÏ¢¡£
Òì³£ÏêϸÐÅÏ¢: System.Exception: δָ¶¨µÄ´íÎó
Ô´´íÎó:
ÐÐ 286: catch ......

access ͬ²½¸´ÖÆÊý¾ÝÎÊÌâ

access ÈçºÎÄܹ»Í¬²½¸´ÖÆÊý¾Ý£¨¾ÖÓòÍøÄÚ²¿¼´¿É£©

ÒªÇóͨ¹ývb6.0±à³ÌʵÏÖ£¬ÔÚaccessÖвÙ×÷µÄÇëÈÆµÀ£¡
1¡¢Ö±½ÓCOPY¡¡MDB£»
2¡¢ÔÚ³ÌÐòÖжÔÁ½¸öMDBÖ´ÐÐÏàͬµÄSQLÓï¾ä£»
3¡¢MDBͬ²½
²Î¿¼
http://www.mb5u.com/biancheng/Access/access_24333.html


{{ ......
×ܼǼÊý:990; ×ÜÒ³Êý:165; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [117] [118] [119] [120] 121 [122] [123] [124] [125] [126]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ