web.config中配置access连接

[技术科]

<add name="OLEDBConn" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\C#试验项目\WebLayer\Web\App_Data\mybbs.mdb"/>
这是网站连接Access文件的连接,现在要求改为相对位置的连接,Access文件位于网站的app_data文件夹下,connectionString该怎么写?

[mahayu1982]

<connectionStrings>
<add name="CustomerDataConnectionString"
connectionString="Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=|DataDirectory|Northwind.mdb"
providerName="System.Data.OleDb" />
</connectionStrings>

[zealot1021]

web.config文件：
<appSetting>
<add key="connectionStr" value="连接字符串内容">
</appSetting>
调用的时候写：
string str=configurationManager.appsetting["connectionStr"].tostring();
oledbconnection con=new oledbconnection(str)

[zealot1021]

把数据库文件的路径指向App_Data文件夹下就行啊

[jiang_jiajia10]

<appSettings>
<add key="OLEDBConn" value="provider=microsoft.jet.oledb.4.0;data source="/>
<add key="dbPath" value="/App_Data/mydata.mdb"/>
</appSettings>
这样写把你的数据库放到app_Data文件夹里

[jiang_jiajia10]

程序里这样写

protected static string GetConnString()
  { 
   return 
System.Configuration.ConfigurationSettings.AppSettings["OLEDBConn"]+   System.Web.HttpContext.Current.Server.MapPath(System.Configuration.ConfigurationSettings.AppSettings["DataPath"])+";";
  }

[koukoujiayi]

.mdb数据库放在App_Data中就不应该再沿用vs2003将代码放在<appSettings> </appSettings> 中,
而应该放在<connectionStrings></connectionStrings>中!!
<connectionStrings>
<add name="AccessConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\your.mdb;Persist Security Info=True"
providerName="System.Data.OleDb" />
</connectionStrings>

[csdm55]

F:\C#试验项目\WebLayer\Web\App_Data\mybbs.mdb改成=|DataDirectory|\your.mdb