在DAL层中, 如何从web.config中读取数据库的连接字符串?

Question

我的web.config文件如下. 大家帮看看, 在线等待
<configuration>
<configSections>
</configSections> <connectionStrings>
<add name="SqlConnString" connectionString="Data Source=server1;Initial Catalog=hrm;Persist Security Info=True;User ID=edi;Password=pwdedi" providerName="System.Data.SqlClient"/> </connectionStrings>
<system.web>
</system.web>
<system.webServer>
</system.webServer>
<location allowOverride="true" inheritInChildApplications="true">
<appSettings>   
  </appSettings>
</location>
</configuration>

Answer 1

System.Configuration.ConfigurationManager.ConnectionStrings["SqlConnString"].ConnectionString

Answer 2

还是跟平常一样啊using System.Configuration;ConfigurationManager.ConnectionStrings["SqlConnString"].ToString()

Answer 3

string strcon=ConfigurationManager.ConnectionString["SqlConnString"].ConnectionString

Answer 4

引用System.Configuration命名空间
跟在页面使用没什么区别

Answer 5

如果DAL是类库项目，除了在代码中using System.Configuration; 外还要在“引用”文件夹右键“添加引用”，找到System.Configuration并确定。

Answer 6

首页在类中添加 using System.Configuration;
然后在项目上右键“添加引用”，找到System.Configuration并添加；
再使用ConfigurationManager.ConnectionStrings["SqlConnString"].ConnectionString.ToString();

Answer 7

添加引用System.Configuration这个命名空间...

Answer 8

添加system.web和System.Web.Configuration引用
SQLHelper:
using System.Web.Configuration; 
public static string getConnStr()
{
return ConfigurationManager.ConnectionStrings["SqlConnString"].ToString();
}
DAL
SQLHelper.getConnStr();

Answer 9

参考:
http://www.cnblogs.com/insus/articles/1405604.html

Answer 10

ASP.NET中读取连接字符串建议使用WebConfigurationManager，如：System.Web.Configuration.WebConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;

Answer 11

类中添加 using System.Configuration
然后添加引用System.Configuration
这样就可以使用ConfigurationManager.ConnectionStrings["connStr"].ConnectionString.ToString()

Answer 12

 ConfigurationManager.ConnectionStrings["RyMedicalConnectionString"].ConnectionString;

Answer 13

ConfigurationManager.ConnectionStrings["SqlConnString"].ToString()