Âé·³¸÷λ°ïæ¿´¿´°¡
´úÂëÈçÏ£º
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 ......
ÓÃC#×öµÄϵͳ£¬Êý¾Ý¿âΪaccess2003£¬ÔõÑù´ò¿ªÏµÍ³£¿accessÊý¾Ý¿âÔõÑù²Ù×÷.mdbÎļþ£¿
Óësql server²Ù×÷Ò»ÑùÂð£¿ÊDz»ÊÇÒ²ÐèÒª¸½¼ÓÊý¾Ý¿â£¿
Çë¼òҪ˵Ã÷һϲ½Öè ллÁË
²¹³äһϣº
ÎÒÓõĿª·¢¹¤¾ßÊÇvs.net 2003
Ó¦¸ÃÓëSQLÀàËÆ,²»¹ýÁ¬½Ó×Ö·û´®ÓÐЩ²»Í¬
ÐèÒª½«.mdbÎļþ¸½¼Óµ½access ÖÐÂð£¿
ÒýÓÃ
Ð ......
ÎÒµÄÓï¾äÊÇ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Êý¾Ý¿âÖеÄÊý¾Ý£¬´úÂëÊÇÔõÑù°¡£¿£¿Çë¸ßÊÖÖ¸µã
oledbconnection
ͬ¥ÉÏ
²Î¿¼ÒÔÏ´úÂë,¿´ÄÜ·ñ½â¾öµ½ÄãµÄÎÊÌâ
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";
strConnection+=@"Data Source=MapPath("Êý¾Ý¿â.mdb");//ÕâÀïÊÇÏà¶Ô·¾¶
......
ÎÒÓõÄÊǶ¯ÍøµÄÁ¬½Ó¿â µÚÒ»´Î´ò¿ªÃ»ÎÊÌâ µ«Êǵ±¶àˢм¸´Îºó³ö´í
C# code:
δָ¶¨µÄ´íÎó
˵Ã÷: Ö´Ðе±Ç° Web ÇëÇóÆÚ¼ä£¬³öÏÖδ´¦ÀíµÄÒì³£¡£Çë¼ì²é¶ÑÕ»¸ú×ÙÐÅÏ¢£¬ÒÔÁ˽âÓйظôíÎóÒÔ¼°´úÂëÖе¼Ö´íÎóµÄ³ö´¦µÄÏêϸÐÅÏ¢¡£
Òì³£ÏêϸÐÅÏ¢: System.Exception: δָ¶¨µÄ´íÎó
Ô´´íÎó:
ÐÐ 286: catch ......
access ÈçºÎÄܹ»Í¬²½¸´ÖÆÊý¾Ý£¨¾ÖÓòÍøÄÚ²¿¼´¿É£©
ÒªÇóͨ¹ývb6.0±à³ÌʵÏÖ£¬ÔÚaccessÖвÙ×÷µÄÇëÈÆµÀ£¡
1¡¢Ö±½ÓCOPY¡¡MDB£»
2¡¢ÔÚ³ÌÐòÖжÔÁ½¸öMDBÖ´ÐÐÏàͬµÄSQLÓï¾ä£»
3¡¢MDBͬ²½
²Î¿¼
http://www.mb5u.com/biancheng/Access/access_24333.html
{{ ......