private string constring=""; 定义一个字符串private void button8_Click(object sender, System.EventArgs e)
{
SqlConnection oCon;
String strcon;
oCon=new SqlConnection();
strcon="Data Source=(local);";
strcon+="Initial catalog=Northwind;";
strcon+="user ID=sa;";
strcon+="password=;";
oCon.ConnectionString=strcon;
oCon.Open(); string sql="select * from Customers";
constring=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
SqlDataAdapter sda =new SqlDataAdapter(sql,constring);
DataSet ds=new DataSet();
sda.Fill(ds); this.dataGrid1.DataSource=ds;
this.DataGrid1.DataBind();//该句编译通不过问题何在
//提示的信息E:\c#\add\Form1.cs(501): “add.Form1”并不包含对“DataGrid1”的定义 oCon.Close();
}
应该如何修改
{
SqlConnection oCon;
String strcon;
oCon=new SqlConnection();
strcon="Data Source=(local);";
strcon+="Initial catalog=Northwind;";
strcon+="user ID=sa;";
strcon+="password=;";
oCon.ConnectionString=strcon;
oCon.Open(); string sql="select * from Customers";
constring=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
SqlDataAdapter sda =new SqlDataAdapter(sql,constring);
DataSet ds=new DataSet();
sda.Fill(ds); this.dataGrid1.DataSource=ds;
this.DataGrid1.DataBind();//该句编译通不过问题何在
//提示的信息E:\c#\add\Form1.cs(501): “add.Form1”并不包含对“DataGrid1”的定义 oCon.Close();
}
应该如何修改
就 是这句通不过啊
{
SqlConnection oCon;
String strcon;
oCon=new SqlConnection();
strcon="Data Source=(local);";
strcon+="Initial catalog=Northwind;";
strcon+="user ID=sa;";
strcon+="password=;";
oCon.ConnectionString=strcon;
string sql="select * from Customers";
SqlDataAdapter sda =new SqlDataAdapter(sql,oCon);
DataSet ds=new DataSet();
sda.Fill(ds);
this.dataGrid1.DataSource=ds;
this.dataGrid1.DataBind();
}
this.DataGrid1.DataBind();//该句编译通不过问题何在
//提示的信息E:\c#\add\Form1.cs(501): “add.Form1”并不包含对“DataGrid1”的定义------------------------------------------------
請注意大小寫問題
{
SqlConnection oCon;
String strcon;
oCon=new SqlConnection();
constring=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
oCon.ConnectionString=constring
string sql="select * from Customers";
SqlDataAdapter sda =new SqlDataAdapter(sql,oCon);
DataSet ds=new DataSet();
sda.Fill(ds);
this.dataGrid1.DataSource=ds;
this.dataGrid1.DataBind();
}