我在WEB.CONFIG里面已经定义咯数据连接，那么我在页面中如何引用

Question

我在WEB.CONFIG里面已经定义咯数据连接 <connectionStrings>
<add name="ConnectionString" connectionString="Provider=MSDAORA;Data Source=xxx;Persist Security Info=True;Password=xxx;User ID=xxx" providerName="System.Data.OleDb"/>
</connectionStrings>
，那么我在页面default.aspx.cs中如何引用

Answer 1

ConfigurationSettings.AppSettings["ConnectionString"]

Answer 2

string StrCnn=ConfigurationSettings.AppSettings["ConnectionString" ];
SqlConn  = new SqlConnection(StrCnn);
SqlConn.Open ();
添加引用using System.Configuration;

Answer 3

SqlConnection cn  = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString" ]);

Answer 4

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using System.Data.SqlClient;public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection StrCnn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
        StrCnn.Open();
        OleDbCommand songcmd = new OleDbCommand("select sbcname from scm_supplierbase where sbid='1002A'", StrCnn);
        string name = (string)songcmd.ExecuteScalar();
        Response.Write(name);
    }
}

Answer 5

出错咯，
1：警告 1 “System.Configuration.ConfigurationSettings.AppSettings”已过时:“This method is obsolete, it has been replaced by System.Configuration!System.Configuration.ConfigurationManager.AppSettings” D:\WebSite1\Default.aspx.cs 17 50 D:\WebSite1\2：错误 2 与“System.Data.OleDb.OleDbCommand.OleDbCommand(string, System.Data.OleDb.OleDbConnection)”最匹配的重载方法具有一些无效参数 D:\WebSite1\Default.aspx.cs 23 32 D:\WebSite1\3：错误 3 参数“2”: 无法从“System.Data.SqlClient.SqlConnection”转换为“System.Data.OleDb.OleDbConnection” D:\WebSite1\Default.aspx.cs 23 108 D:\WebSite1\