需要在项目中添加引用Maticsoft.DBUtility.dll 下载
App.config如下
<?xml version="1.0" encoding="utf-8" ?> <configuration> <appSettings> <!-- 连接字符串是否加密 --> <add key="ConStringEncrypt" value="false"/> <add key="ConnectionString" value="Data Source=127.0.0.1;Initial Catalog=TenderDB;User ID=sa;Password=sa" /> <!-- 注释开始 <add key="ConnectionString" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=config/TestData.mdb" /> 注释结束 --> </appSettings> <!-- 注释开始 <connectionStrings> <add name="FG_conn" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=config/TestData.mdb" providerName="System.Data.OleDb" /> </connectionStrings> 注释结束 --> <startup> <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.7.2" /> </startup> </configuration>
复制代码如下:
<?xml version="1.0" encoding="utf-8" ?> <configuration> <appSettings> <!-- 连接字符串是否加密 --> <add key="ConStringEncrypt" value="false"/> <add key="ConnectionString" value="Data Source=127.0.0.1;Initial Catalog=TenderDB;User ID=sa;Password=sa" /> <!-- 注释开始 <add key="ConnectionString" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=config/TestData.mdb" /> 注释结束 --> </appSettings> <!-- 注释开始 <connectionStrings> <add name="FG_conn" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=config/TestData.mdb" providerName="System.Data.OleDb" /> </connectionStrings> 注释结束 --> <startup> <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.7.2" /> </startup> </configuration>
原文:https://www.cnblogs.com/francoguo/p/12221176.html