由于ASP.NET2.0的web.config文件新增了一个connectionStrings节,使用configuration.appsettings无法读取连接字符串,用如下方法才能正常读取:
方法1、
Configuration rootWebConfig =WebConfigurationManager.OpenWebConfiguration(Request.ApplicationPath);
ConnectionStringSettings connString=rootWebConfig.ConnectionStrings.ConnectionStrings["ConnectionString"];
SqlConnection myConnection = new SqlConnection(connString.ToString());
方法2、
ConnectionStringSettings connString = WebConfigurationManager.ConnectionStrings["ConnectionString"];
使用时应引用System.Web.Configuration命名空间。
方法1、
Configuration rootWebConfig =WebConfigurationManager.OpenWebConfiguration(Request.ApplicationPath);
ConnectionStringSettings connString=rootWebConfig.ConnectionStrings.ConnectionStrings["ConnectionString"];
SqlConnection myConnection = new SqlConnection(connString.ToString());
方法2、
ConnectionStringSettings connString = WebConfigurationManager.ConnectionStrings["ConnectionString"];
使用时应引用System.Web.Configuration命名空间。