asp.net 读取 connectionStrings
connectionStrings
在vs.net 2005 beta 2开始,如果你在web.config中使用了数据库连接字符串的配置,那么应该按如下的方法去写:
然后在程序中如下进行读取:
<connectionStrings>
<add name="NorthwindConnectionString" connectionString="Data Source=LIAO;Initial Catalog=Northwind;User ID=sa;Password=xxxx" providerName="System.Data.SqlClient"/>
</connectionStrings>
然后在程序中如下进行读取:
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString1"].ConnectionString);
但是要注意在项目中添加 System.Configuration引用
在文件的上引用using System.Configuration;
方法二:
string connString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["sqlConnectionString"].ToString();
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["aConnectionString"].ConnectionString);