关于在webconfig文件中设置connectionString的问题

Question

在WebConfig文件中可以设置两个或两个以上的ConnectString吗?如果可以为什么我设了之后调试报错:说找不到Configuration元素呢?应该怎样设置?请高手指教

Answer 1

<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<appSettings/>
<connectionStrings>
  <add name="TableConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True"
   providerName="System.Data.SqlClient" />
    
  <add name="PubsConnectionString" connectionString="Data Source=localhost;Initial Catlog=pubs;Integrated Security =True" providerName="System.Data.SqlClient"/>
     </connectionStrings>这是webconfig我的配置情况
报错信息是:"未能找到元素 http://schemas.microsoft.com/.NetConfiguration/v2.0:configuration 的架构信息 "

Answer 2

呵呵，没事，xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0"
这个网页打不了，我的也出错了，把这行去掉就行了，不去也没事，不影响什么

Answer 3

<add key="ConnectionSqlServer" value="Server=(local);User id=sa;Pwd=;Database=yksl"></add>
 <add key="ConnectionSqlServer2" value="Server=111.111.111.111;User id=sa;Pwd=;Database=yksl22222"></add>

Answer 4

string ConnString=System.Configuration.ConfigurationSettings.AppSettings["ConnectionSqlServer"];

Answer 5

2005里面
 <appSettings/>
    <connectionStrings>
        <add name="DatabaseConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True"
            providerName="System.Data.SqlClient" />
    </connectionStrings>
不用这样,用
System.Web.Configuration.WebConfigurationManager.ConnectionStrings["DatabaseConnectionString"].ConnectionString;

Answer 6

看看IIS你的虚拟目录中－属性－asp.net选项卡是1.1的还是2.0的

Answer 7

我是这样做的:
1、web.config里:
<configuration>
<connectionStrings/>
  <appSettings>
    <add key="Provider" value="Server=10.0.0.3;Database=Sales;uid=sa;pwd=ice" />
    <add key="Sqlstr" value="Server=10.0.0.5;Database=UserInfo;uid=sa;pwd=ice" />
  </appSettings>
</configuration>
2、cs文件里调用：
public static readonly string sConnstr = ConfigurationSettings.AppSettings["Provider"];///  调用第一个
public static readonly string sConnstr = ConfigurationSettings.AppSettings["Sqlstr"];///  调用第二个