我已经在公共类定义了myConnecton了,可是还是提示我说:ConnectionString 属性尚未初始化。protected SqlConnection myConneciton=new SqlConnection();
private void BindData()
{
string selCmd="select * from Guestbook where (ParentID=0)order by PostTime DESC";
SqlDataAdapter da=new SqlDataAdapter(selCmd,myConnection);
DataSet ds=new DataSet();
da.Fill(ds,"word");
DataGrid1.DataSource = ds.Tables["word"].DefaultView;
DataGrid1.DataBind();
}
private void BindData()
{
string selCmd="select * from Guestbook where (ParentID=0)order by PostTime DESC";
SqlDataAdapter da=new SqlDataAdapter(selCmd,myConnection);
DataSet ds=new DataSet();
da.Fill(ds,"word");
DataGrid1.DataSource = ds.Tables["word"].DefaultView;
DataGrid1.DataBind();
}
{
string selCmd="select * from Guestbook where (ParentID=0) order by PostTime DESC";
SqlDataAdapter da=new SqlDataAdapter(selCmd,myConnection);
DataSet ds=new DataSet();
da.Fill(ds,"word");
DataGrid1.DataSource = ds.Tables["word"].DefaultView;
DataGrid1.DataBind();
}
private void Page_Load(object sender, System.EventArgs e)
{
if(Session.Count==0)
{
Response.Redirect("Login.aspx");
}
else if(!IsPostBack)
{
Label1.Text="欢迎"+Session["username"].ToString();
string strConn="server=localhost;uid=sa;pwd=;database=Guestbook";
SqlConnection myConnection=new SqlConnection();
myConnection.ConnectionString=strConn;
BindData();
}
}这是我整段程序...
myConnecton.ConnectionString = "server=(local);Integrated security = true;
database = Northwind;";
接着调用:myConnecton.Open();
之后:就可以
private void BindData()
{
string selCmd="select * from Guestbook where (ParentID=0) order by PostTime DESC";
SqlDataAdapter da=new SqlDataAdapter(selCmd,myConnection);
DataSet ds=new DataSet();
da.Fill(ds,"word");
DataGrid1.DataSource = ds.Tables["word"].DefaultView;
DataGrid1.DataBind();
}
{
string selCmd="select * from [Guestbook] where(ParentID=0) order by PostTime DESC";
string strConn="server=localhost;uid=sa;pwd=;database = Guestbook";
SqlConnection myConnection=new SqlConnection();
myConnection.ConnectionString=strConn;
SqlDataAdapter da=new SqlDataAdapter(selCmd,myConnection);
DataSet ds=new DataSet();
da.Fill(ds,"word");
DataGrid1.DataSource = ds.Tables["word"].DefaultView;
DataGrid1.DataBind();
}我打开后,还是出错,提示说对象名Guestbook无效...怎么办?