请教怎么读取web.config里面数据库的名称？

Question

我有个备份SQL数据库的程序，
但我想在cs里面直接读取web.config里面数据库的名称
web.config里面数据库连接字符：  <connectionStrings>
  <add name="SQLCONNECTIONSTRING" connectionString="data source=localhost;User ID=sa;pwd=1234567;Initial Catalog=UDS"  providerName="System.Data.SqlClient" />
</connectionStrings>
..............

Answer 1

直接定义字符串就可以了啊。
protected string strConnection = "SQLCONNECTIONSTRING";

Answer 2

string strCon = System.Configuration.ConfigurationManager.ConnectionStrings["sql"].ToString();

Answer 3

System.Web.Configuration.CongiruationManager.ConnectionStrings["SQLCONNECTIONSTRING"].ConnectionString;

Answer 4

SqlConnection myConn = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLCONNECTIONSTRING"].ConnectionString);

Answer 5

string connectionString =ConfigurationManager.ConnectionStrings["connection"].ConnectionString;

Answer 6

SqlConnection myConn = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLCONNECTIONSTRING"].ConnectionString);
正解！！！

Answer 7

利用DbProviderFactory来创建连接对象,有了对象后,你就知道是哪个database了.

Answer 8

是这么个意思，自己看着修改 Dictionary<string, string> allKeyValue = new Dictionary<string, string>();
        string connection = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
        string[] node = connection.Split(new char[] { ';' });
        for (int i = 0; i < node.Length; i++)
        {
            if (!node[i].Contains("="))
                continue;
            string[] templist = node[i].Split('=');
            if (!allKeyValue.ContainsKey(templist[0]))
            {
                allKeyValue.Add(templist[0], templist[1]);
            }        }
        string str_DataSource = allKeyValue["Data Source"];