1
é¦å ç¡®ä¿Accessä¸å¼åå·¥å ·Visual Studioé½æ£ç¡®å®è£ äºï¼å¦æ没å®è£ çè¯éè¦ä¸è½½ç¸å ³ç软件å®è£ ä¸ä¸ï¼Visual Studioä¸éå¶ä½ ççæ¬ï¼2012ï¼2008ä»ä¹çé½è¡ã
2
ç¶åå¨ä¸ä¸ªç符ä¸å³é®å建ä¸ä¸ªaccessæ件ï¼æ¯å¦æå建äºä¸ä¸ªaaa.accdb ,注æAccess07ä¹åä½ å建çè¯åç¼åé½æ¯.mdbè07å10çæ¬åç¼åå·²ç»ä¸º.accdbäºãè¿ä¸ªéè¦ä½ çæçï¼å 为ä¸åçåç¼åå½±åä¸é¢çè¿æ¥çã
3
ç¶åæ们å¨Accessä¸æ·»å ä¸ä¸ªæ°æ®è¡¨(tb_test)ï¼é便å å åå 容ï¼å¦ä¸æ示ï¼
4
æå¼Visual Studioï¼æ°å»ºä¸ä¸ªWinformçªä½ï¼å¨çªä½ä¸æ¾ä¸ä¸ªbuttonæé®ï¼å©ä¸çå°±æ¯ä¹¦åç¹å»æé®åçæ¹æ³äº
5
ç¹å»buttonæé®åæ们è¦åçå°±æ¯è¿æ¥æ°æ®åºï¼ç¶åæ¥è¯¢æ°æ®åºä¸æ们åææ°å»ºç表ï¼å°å ¶èµå¼ç»ä¸ä¸ªDataSetãæ们å æ¥ççæä¹æä¹è¿æ¥ãè¿æ¥è¦ç¨å°è¿æ¥å符串ï¼è¿ä¸ªå°±åä¸é¢æ们说çåç¼åæèç³»äºã注æ.mdbå.accdbçè¿æ¥æ¹å¼æ¯ä¸ä¸æ ·çï¼åå«å¦ä¸ï¼
string ConStr_Accdb = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=F:\aaa.accdb;Persist Security Info=False;";
string ConStr_Mdb = @"Provider=Microsoft.ACE.OLEDB.4.0;Data Source=F:\aaa.accdb;Persist Security Info=False;";
6
æ¼æ¥å¥½è¿æ¥å符串以åï¼ä¸é¢å°±æ¯å»ºç«è¿æ¥è·åæ°æ®äºï¼è¿æå°±ä¸å¤è¯´äºï¼ä»£ç æªå¾æ´ä½å¦ä¸ï¼
7
åå®äºä»¥åä½ è¿è¡ä»¥åï¼å¯è½ä¼æ¥å¦ä¸çé误ï¼æªå¨æ¬å°è®¡ç®æºä¸æ³¨åmicrosoft.ace.12.0ãè¿ä¸ªæ¯ç±äºè®¡ç®æºä¸ç¼ºå°é©±å¨ç¨åºé æçï¼å»å®ç½ä¸è½½å®è£ å³å¯ï¼
http://download.microsoft.com/download/7/0/3/703ffbcb-dc0c-4e19-b0da-1463960fdcdb/AccessDatabaseEngine.exe
8
å°è¿éè¿æ¥Accessæ°æ®åºçæ¹æ³å°±è®²è§£å®äºï¼æ们ç¨çæ¯netï¼ä½ å¦æç¨å«çè¯è¨ï¼æ¥éª¤ä¹ä¸æ ·ï¼åªä¸è¿æ¢ä¸ä¸æ°å»ºè¿æ¥çæ¹å¼å³å¯ã
END