通过web.config文件连接access

1.新建立website,数据库放在app_code下,数据库文件Data.mdb

2.在web.config中的配置:

<appsettings></appsettings>

<add key="dbprovider" value="Provier=Microsoft.Jet.Oledb.4.0;"></add>

<add key="dbpath" value="App_Data/Data.mdb"></add>

 <appSettings>

 <appSettings>
<add key="AdminPages" value="Form.aspx,FormEdit.aspx,User.aspx,UserEdit.aspx"></add>
<add key="AdminPages" value="Form.aspx,FormEdit.aspx,User.aspx,UserEdit.aspx"></add>3.建立classlibrary,命名King.Base,连接数据库的基类:BaseObject:

namespace King.Base
{
    public class BaseObject
    {
        protected string SqlConnectionString;

        public BaseObject()
        {
            string dbprovider= ConfigurationManager.AppSettings["dbprovider"];
            string dbpath;

            dbpath = HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dbpath"]);
            SqlConnectionString = dbprovider + "Data Source=" + dbpath;
          
         

          
        }

        public static string ConvertToSqlString(string sql)
        {
            sql = sql.Replace("'", "''");
            sql = sql.Replace("[", "[[]");
            sql = sql.Replace("%", "[%]");
            return sql;

        }

    }
<add key="AdminPages" value="Form.aspx,FormEdit.aspx,User.aspx,UserEdit.aspx"></add>
<add key="dbprovider" value="Provider=Microsoft.Jet.OLEDB.4.0;"></add>
<add key="dbpath" value="App_Data/Data.mdb"></add>