从web.config读取设置 [英] Read setting from web.config

问题描述

如何从web.config中读取连接字符串设置
这是我的示例代码

How to read connection string setting from web.config
here is my sample code

string connect= ConfigurationSettings.AppSettings["myconnection"];
    SqlConnection sqlConn = new SqlConnection(connect);
    sqlConn.Open();
    SqlCommand cmd = sqlConn.CreateCommand();

<appsettings>
       <connectionstrings>
    <add name="myconnection" connectionstring="server=SERVER1\\MSSQLSERVER2008;database=DataConverter;uid=sa;password=sa;" />
    </connectionstrings>
  </appsettings>

但无法使用.net2.o和sqlserver2008
无法读取具有上述语法的连接字符串，无法获取空字符串

but it not working am using .net2.o and sqlserver2008
am unable to read connection string with the above syntax,am getting a Null string

推荐答案

对于3.5

For 3.5

//to read
ConnectionStringSettings connection = ConfigurationManager.ConnectionStrings["MyConnectionString"]
string connectionString = connection.ConnectionString

<configuration>
<connectionStrings>
<add connectionString="" providerName="" name="MyConnectionString"/>
</connectionStrings>
</configuration>

对于2.0

For 2.0

<appSettings>
<add key="myConnectionString" value=";" />
</appSettings>

//to read
string connStr = ConfigurationSettings.AppSettings("myConnectionString");

或将您的配置更改为

Or change your config as

<appsettings>
      <add key="myconnection" value="server=SERVER1\\MSSQLSERVER2008;database=DataConverter;uid=sa;password=sa;"/>
</appsettings>

参考: http://odetocode.com/code/345.aspx [

Ref: http://odetocode.com/code/345.aspx[^]

将连接字符串放入web.config

put your connection string in web.config

<appSettings>
<add key="myConnectionString" value="server=localhost;database=myDb;uid=myUser;password=myPass;" />
</appSettings>

并检索代码.

and retrive in code.

string connStr = ConfigurationSettings.AppSettings("myConnectionString");

这篇关于从web.config读取设置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！