最近有个同学碰到问题,就是Access数据库连接的相对路径问题.
当然使用Web.config来保存数据库的连接便于数据库的移植以及一些不定性因素,总之就是好维护了.
1.在Web.Config添加:
<
connectionStrings
>
< add name = " db1ConnectionString " connectionString = " Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}App_Datadb1.mdb "
providerName = " System.Data.OleDb " />
</ connectionStrings >
< add name = " db1ConnectionString " connectionString = " Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}App_Datadb1.mdb "
providerName = " System.Data.OleDb " />
</ connectionStrings >
2,然后连接字符串使用Format格式化即可.在数据库操作的类或者在代码里面就是如下引用了
private
static
string
connString
=
string
.Format(ConfigurationManager.ConnectionStrings[
"
db1ConnectionString
"
].ToString(),System.Web.HttpContext.Current.Server.MapPath(
"
.
"
));