1.在web.config 中设置好连接串:
<appSettings>
<add key="connString" value="Provider=Microsoft.Jet.OLEDB.4.0; Data Source="/>
<add key="databasePath" value="~/App_Data/XXXXX.mdb;"/>
<add key="password" value="jet oledb:database password=XXXXXX;"/>
</appSettings>
2.创建一个DbClass类
将连接串进行组合:(注意加入using System.Data.OleDb;)
public static OleDbConnection Getconn()
{ string connString=System.Configuration.ConfigurationManager.AppSettings["connString"].ToString();
string databasePath=HttpContext.Current.Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["databasePath"].ToString());
//在非WEB页面类中引用Server的时候要把命名空间带上。System.Web.HttpContext.Current.Server.MapPath("");
string password=System.Configuration.ConfigurationManager.AppSettings["password"].ToString();
connString= connString+databasePath+password;
OleDbConnection myconn = new OleDbConnection(connString);
return myconn;
}