»ùÓÚvB¿ª·¢.ÒªÓеãÉî¶ÈµÄº¬Á¿µÄ.ºÍ¹¤×÷Á¿µÄ,µ«²»¹ýÓÚ¸´ÔÓ,ÒòΪÎÒVBÒ²²»ºÜͨ.ÎÒ¿ÉÒÔ×Ô¼ºÂýÂýÑо¿.лл!
²»ÖªµÀÓÃ;¾ÍÎÞ·¨ÖªµÀ¹¤×÷Á¿ºÍÉî¶È,Ò²¾ÍÎÞ·¨³öÌâÄ¿
×ö畢業設計嗎;
ºÇºÇ£¬¹À¼ÆÊÇ
ʲôÇé¿ö,˵Çå³þµãÈý
¼Û¸ñºÏÊʵϰ,ÁªÏµ 530496014
ÒªÓеãÉî¶ÈµÄº¬Á¿µÄ.ºÍ¹¤×÷Á¿µÄ,µ«²»¹ ......
Âé·³¸÷λ°ïæ¿´¿´°¡
´úÂëÈçÏ£º
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");//ÕâÀïÊÇÏà¶Ô·¾¶
......
ÎÒ×Ô¼º×öÁ˸öÈí¼þ£¬ÓÐÒ»¶¨µÄʹÓüÛÖµ£¬²»ÖªµÀÔõÑùÀûÓÃÒ»»úÒ»ÂëµÄ¼¼ÊõÉÔ΢±£»¤Ò»ÏÂ×Ô¼ºµÄ³É¹û£¬ÓÐÕâ·½Ãæ¾ÑéµÄ´ó¸ç´ó½ãÄÜ·ñ¸øÓèÖ¸µã£¬ÓÐÏֳɵĴúÂë¾Í×îºÃÁË£¬Íò·Ö¸Ðл¡£
À´Ñ§Ï°Ï¡£
¸ã¸ö¼ÓÃܹ·¹þ¡£
Ò»°ã¾ÍÊÇͨ¹ý»ñÈ¡CPU»òÓ²ÅÌÐòÁкÅ,Éú³É»úÆ÷Âë,ÔÙ¸ù¾Ý»úÆ÷ÂëÉú³ÉÐòÁкš£ÕâÑùÐòÁкžÍʵÏÖºÍÓ²¼þ¹ØÁªÁË¡£
¸ùé§Ó²¼ ......