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

Question

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" />
这样行不行?

Answer 1

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

Answer 2

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

Answer 3

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

Answer 4

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)

Answer 5

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

Answer 6

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

Answer 7

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