在Web.config配置的数据库连接字符串

[greatverve]

1.Web.config中配置
<appSettings>
<connectionStrings>
<add name="connStr" connectionString="Data Source=.;Initial Catalog=master;User ID=sa;Password=123" providerName="System.Data.SqlClient"/>
</connectionStrings>
</appSettings>
2.请问用什么代码取得这个连接?
string str=ConfigurationSettings.AppSettings[connStr];
不行.为什么?
3.关于Access
string str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("App_Data/db.mdb");
在Web.config中怎样定义这个字符串?
<add name="connStr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="~/App_Data/db.mdb" />
这样行不行?

[greatverve]

<add name="con" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|book.mdb"/>
这里能不能是
DataSource=~/App_Data/book.mdb?

[greatverve]

我试了,用|dir|db.mdb也不行.算了,这个问题不管了,一般用不着.谢谢二楼.

[编程有钱人了]

  <connectionStrings>
    <add name="con" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|book.mdb"/>
  </connectionStrings>

[编程有钱人了]

 OleDbConnection conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);

[jaredzeng]

楼上正解

[辉之不趣]

2　string str=ConfigurationSettings.AppSettings[connStr]; 不行
得　string str=ConfigurationSettings.AppSettings["connStr"];

[xuezj508]

ConfigurationManager.ConnectionStrings["connStr"].ConnectionString


<add name="db_access" connectionString="provider=microsoft.jet.oledb.4.0;data source="/>
<add name="db_path" connectionString="App_Data/experts.mdb"/>
再ConfigurationManager.ConnectionStrings["db_access"].ConnectionString+Server.MapPath(ConfigurationManager.ConnectionStrings["db_path"].ConnectionString)

[lonelygames]

这样试试
2 string str=ConfigurationSettings.AppSettings["connStr"];
3 <add name="connStr" connectionString="Source="~/App_Data/db.mdb" providerName="Microsoft.Jet.OLEDB.4.0;Data"/>

[halk]

都别说了，2楼正解，很直接的事情别搞恁复杂