数据库的连接最好在web.config里面设置,代码如下:
<?xml version="1.0"?>
<configuration>
<system.web>
<customErrors defaultRedirect=""/>
<compilation debug="true"/>
<appSettings>
<add key="win" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="/>
<add key="dbPath" value="~/App_Data/数据库名称.mdb"/>
</appSettings>
</configuration>
上面是设置好的数据库地址,下面是在cs里面的连接方法:
string MyConnString =ConfigurationSettings.AppSettings["win"].ToString() + HttpContext.Current.Server.MapPath(ConfigurationSettings.AppSettings["dbPath"])+";";
Connection = new OleDbConnection(MyConnString);
Connection.Open();