在Web.config文件中,添加如下内容:
<?xml version="1.0"?><!--有关如何配置 应用程序的详细信息，请访问/fwlink/?LinkId=169433--><configuration><system.web><compilation targetFramework="4.0" debug="true"/><customErrors mode="Off"/></system.web><connectionStrings><add name="connString" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|/mydb.accdb;Persist Security Info=True;User ID=admin" providerName="System.Data.OleDb"/></connectionStrings></configuration><!--ProjectGuid: 61651E6D-2C16-4AAA-836E-A750E7EE7FE5-->
Web.config文件放在网站的根目录下。
在Bin的同级目录，创建App_Data文件夹。将数据库文件mydb.accdb放这个文件夹下。
数据库操作，代码如下：
//数据库更新,增,删,改public static int Update(string sql){OleDbConnection objConnection = new OleDbConnection(connString);try{objConnection.Open();var cmd = new OleDbCommand(sql,objConnection);return cmd.ExecuteNonQuery();}catch (Exception ex){WriteTextLog("Update",sql+"执行更新时发生异常" + ex.Message, DateTime.Now);throw ex;}finally{objConnection.Close();}}//返回单一结果,聚合函数,select @@identitypublic static object GetSingleResult(string sql){OleDbConnection objConnection = new OleDbConnection(connString);try{objConnection.Open();var cmd = new OleDbCommand(sql,objConnection);return cmd.ExecuteScalar();//返回object类型}catch (Exception ex){WriteTextLog("GetSingleResult", sql+"执行时发生异常" + ex.Message, DateTime.Now);throw ex;}finally{objConnection.Close();}}//返回结果集public static OleDbDataReader GetReader(string sql){OleDbConnection objConnection = new OleDbConnection(connString);try{objConnection.Open();var cmd = new OleDbCommand(sql,objConnection);return cmd.ExecuteReader (CommandBehavior.CloseConnection);//不能在此关闭连接}catch (Exception ex){objConnection.Close();objConnection.Dispose();WriteTextLog("GetReader",sql+ "执行时发生异常" + ex.Message, DateTime.Now);throw ex;}}
