.net中使用OleDb连接Access数据库

偏执的太偏执、 2022-08-26 05:58 210阅读 0赞

1. 在Web.config文件中加入以下配置：

![None.gif][] < configuration >   
![None.gif][] < appSettings >   
![None.gif][] < add  key ="DataBasePath"  value ="~/Database/Financial.mdb" />

![None.gif][] </ appSettings >   
![None.gif][] </ configuration >   
![None.gif][]

2.新建一个Utility类，内容如下：

![None.gif][] namespace  Web.Common  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][] ... \{  
![ExpandedSubBlockStart.gif][]![ContractedSubBlock.gif][]/\*\*////<summary>  
![InBlock.gif][]/// Utility 的摘要说明。  
![ExpandedSubBlockEnd.gif][]///</summary>  
![InBlock.gif][]publicclass Utility  
![ExpandedSubBlockStart.gif][]![ContractedSubBlock.gif][]...\{  
![InBlock.gif][]public Utility()  
![ExpandedSubBlockStart.gif][]![ContractedSubBlock.gif][]...\{  
![InBlock.gif][]//  
![InBlock.gif][]// TODO: 在此处添加构造函数逻辑  
![InBlock.gif][]//  
![ExpandedSubBlockEnd.gif][] \}  
![InBlock.gif][]  
![ExpandedSubBlockStart.gif][]![ContractedSubBlock.gif][]/\*\*////<summary>  
![InBlock.gif][]/// 得到一个OleDbConnection字符串  
![InBlock.gif][]///</summary>  
![ExpandedSubBlockEnd.gif][]///<returns>OleDbConnection连接字符串</returns>  
![InBlock.gif][]publicstring GetOleDbConnectionString()  
![ExpandedSubBlockStart.gif][]![ContractedSubBlock.gif][]...\{  
![InBlock.gif][]string prefixConnStr ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";  
![InBlock.gif][]string databasePath = System.Configuration.ConfigurationSettings.AppSettings\["DataBasePath"\];  
![InBlock.gif][]  
![InBlock.gif][] prefixConnStr \+= System.Web.HttpContext.Current.Server.MapPath(databasePath);  
![InBlock.gif][]  
![InBlock.gif][]return prefixConnStr;  
![ExpandedSubBlockEnd.gif][] \}  
![InBlock.gif][]  
![ExpandedSubBlockStart.gif][]![ContractedSubBlock.gif][]/\*\*////<summary>  
![InBlock.gif][]/// 得到一个OleDbConnection对象，返回值需要判断是否为null。  
![InBlock.gif][]///</summary>  
![ExpandedSubBlockEnd.gif][]///<returns>OleDbConnection对象</returns>  
![InBlock.gif][]public OleDbConnection GetOleDbConnection()  
![ExpandedSubBlockStart.gif][]![ContractedSubBlock.gif][]...\{  
![InBlock.gif][]try  
![ExpandedSubBlockStart.gif][]![ContractedSubBlock.gif][]...\{  
![InBlock.gif][] OleDbConnection conn =new OleDbConnection(GetOleDbConnectionString());  
![InBlock.gif][] conn.Open();  
![InBlock.gif][]return conn;  
![ExpandedSubBlockEnd.gif][] \}  
![InBlock.gif][]catch  
![ExpandedSubBlockStart.gif][]![ContractedSubBlock.gif][]...\{  
![InBlock.gif][]returnnull;  
![ExpandedSubBlockEnd.gif][] \}  
![ExpandedSubBlockEnd.gif][] \}  
![InBlock.gif][]  
![ExpandedSubBlockEnd.gif][]\}  
![InBlock.gif][]

说明：本例假设Financial.mdb 数据库存在于项目的Database文件夹下，在创建了Utility类后，通过本类的GetOleDbConnection()即可得到OleDb的Collection对象。

[None.gif]: /images/20220824/eac31d1a666748e88160e7c9a406397d.png
[ExpandedBlockStart.gif]: http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockStart.gif
[ContractedBlock.gif]: /images/20220824/86d8e320758d4055ac7e71adf3a05a0e.png
[ExpandedSubBlockStart.gif]: http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedSubBlockStart.gif
[ContractedSubBlock.gif]: /images/20220824/1a8550560b2048dc8f4b01c8a0ec0526.png
[InBlock.gif]: /images/20220824/c450ba40bcd346ef9114fa3679d7bc07.png
[ExpandedSubBlockEnd.gif]: /images/20220824/65b6ac7761154834820df83f923eaf0d.png