在ASP.net中连接Access2007数据库

在Web.config文件中,添加如下内容:

<?xml version="1.0"?>
<!--
  有关如何配置 ASP.NET 应用程序的详细信息，请访问
  http://go.microsoft.com/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放这个文件夹下。
数据库操作，一般会定义一个SqlHelper类，来操作数据库。代码如下：

public class SQLHelper
{
        //数据库连接字符串
        private static string connString = ConfigurationManager.ConnectionStrings["connString"].ToString();
        //数据库增、删、改、查
        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 @@identity
        public 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;
            }
        }
}