数据库连接参数写在 Web.config文件中，在ASP。NET只怎么得到它啊？

Question

<appSettings> 
  <add key="CnString" value="User ID=sa;Data Source=192.168.1.103;password=;Initial Catalog=video;Provider=SQLOLEDB.1" />
  <!--<add key="CnString" value="User ID=sa;Data Source=192.168.1.103;Initial Catalog=video;Provider=SQLOLEDB.1" />--> 
  <add key="DayDelay" value="3" />
  </appSettings> 
在代码中怎么得到 CnString  这个变量啊

Answer 1

首先要using System.Configuration; ConfigurationSettings.AppSettings["CnString"];

Answer 2

http://www.microsoft.com/china/community/program/originalarticles/TechDoc/duwamish_con.mspxhttp://www.sharppower.com/Products/RapTier/Doc/Templates/TableGatewayTemplate/DBTier/ExtendingDBTierCode/StoringConnectionString.htm

Answer 3

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings>
<add key="sqlDB" value="server=localhost;uid=DBMT60_ADM;pwd=sdadm;database=DBMT60"></add>
<add key="sqllink" value="server=yfq-001;uid=ADM;pwd=sdadm;database=DBMT50"></add>
<add key="sqllink1" value="server=SSCSERVER;uid=DBMT60_ADM;pwd=sdadm;database=DBMT60"></add>
<add key="sqllink3" value="server=192.168.0.135;uid=;pwd=;database=DBMT50"></add>

</appSettings>string connstr=System.Configuration.ConfigurationSettings.AppSettings["sqllink"];
SqlConnection conn=new SqlConnection(connstr);
conn.Open();

Answer 4

对；
在声明中写using System.Configuration;
然后在页面中写：String strMyConn = System.Configuration.ConfigurationSettings.AppSettings["CnString"];