sqlconnetion 链接数据库问题

[enasp]

web.config

  <appSettings>
    <add key="connstring" value="server=192.168.1.2;uid=sa;pwd=200;database=test"></add>
  </appSettings>

代码：

    protected void Page_Load(object sender, EventArgs e)
    {
     
        if (!Page.IsPostBack)
        {
            this.bindtogridview();
        }
    }

private void bindtogridview()
    {
       
        string strconnection = ConfigurationSettings.AppSettings("connstring");
         SqlConnection myconnection = new SqlConnection(strconnection);
        myconnection.Open();
        SqlDataAdapter sda = new SqlDataAdapter();
        sda.SelectCommand = new SqlCommand("select * from t", myconnection);
        DataSet ds = new DataSet();
        sda.Fill(ds, "test");
        this.GridView1.DataKeyNames = new string[] { "id" };
        this.GridView1.DataSource = ds.Tables["test"];
        this.GridView1.DataBind();
    }

报错：

错误 1 不能像使用方法那样使用不可调用的成员“System.Configuration.ConfigurationSettings.AppSettings”。 C:\Documents and Settings\Administrator\My Documents\Visual Studio 2008\WebSites\WebSite1\Default.aspx.cs 43 54 C:\...\WebSite1\

[wuyq11]

System.Configuration.ConfigurationManager.AppSettings[""]

[木偶哈哈哈]

导入，命名空间，
using System.configuration;
然后，将，
private void bindtogridview()
方法中的，
string strconnection = ConfigurationSettings.AppSettings("connstring");
改成，
string strconnection = System.configuration.ConfigurationManger.AppSettings["connstring"];
或者
string strconnection = System.configuration.ConfigurationSettings.AppSettings["connstring"];
后者容易失效，，不过能用

[wangbin1986]

SqlConnection myconnection = new SqlConnection();
myconnection .ConnectionString = ConfigurationManager.ConnectionStrings["connstring"].ConnectionString;

[amanizty]

[Quote=引用 3 楼 wangbin1986 的回复:]
SqlConnection myconnection = new SqlConnection();
myconnection .ConnectionString = ConfigurationManager.ConnectionStrings["connstring"].ConnectionString;
[/Quote]

up~~

[Fibona]

ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["connstring"].ConnectionString;

[zhnzzy]

  string strconnection =System.Configuration.ConfigurationSettings.AppSettings["connstring"]

[ReyZhang]

string strconnection =System.Configuration.ConfigurationManager.AppSettings["connstring"]

[泡面之夏]

using System.configuration;

protected void Page_Load(object sender, EventArgs e)
{

if (!Page.IsPostBack)
{
this.bindtogridview();
}
}

private void bindtogridview()
{

string strconnection =ConfigurationManager.ConnectionStrings["connstring"];
SqlConnection myconnection = new SqlConnection(strconnection);
myconnection.Open();
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = new SqlCommand("select * from t", myconnection);
DataSet ds = new DataSet();
sda.Fill(ds, "test");
this.GridView1.DataKeyNames = new string[] { "id" };
this.GridView1.DataSource = ds.Tables["test"];
this.GridView1.DataBind();
}

[fffff_1982]

回答完了

[XiaoSanLun]

在表示层要导入Configuration dll文件

[claymore1114]

using System.Configuration
string strconnection =ConfigurationManager.AppSettings["connstring"]

[fayxue]

ConnectionString constr = System.Configuration.ConfigurationManager.ConnectionStrings["connstring"].ConnectionString;

[jiang_jiajia10]

SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["connstring"]); //创建连接对象

[jiang_jiajia10]

ConfigurationSettings.AppSettings("connstring");
你怎么给写成()了是[]