为什么连接不上数据库？

Question

SqlConnection cn = new SqlConnection("server=web;database=wlud;uid=sa;password=lhj123");
try
{
cn.Open();
SqlDataAdapter da = new SqlDataAdapter("select * from scjyc_article",cn);
DataSet ds = new DataSet();
da.Fill(ds,"test");
this.DataGrid1.DataSource = ds.Tables["test"];
this.DataGrid1.DataBind();
}
catch(Exception ex)
{
Response.Write(ex.Message);
}
finally
{
if(cn.State != ConnectionState.Closed)
{
cn.Close();
}
}

Answer 1

SqlConnection cn = new SqlConnection("server=web;database=wlud;uid=sa;password=lhj123")改为SqlConnection cn = new SqlConnection("server=web;database=wlud;uid=sa;pwd=lhj123")
 试一试...

Answer 2

本人菜鸟一只，无法看出错误，帮你up
up
up

Answer 3

private  DataSet  GetProductData()     
{     
SqlConnection myConn = new SqlConnection("server=wayne;uid=sa;pwd=;database=Northwind");
string strSQL1="select LastName,FirstName from  Employees";
SqlDataAdapter Adapter1= new SqlDataAdapter(strSQL1, myConn);
DataSet ds = new DataSet();
Adapter1.Fill(ds,"Employees");
return ds;
}    
protected  void  BindGrid()     
{     
MyDataGrid.DataSource=GetProductData().Tables["Employees"].DefaultView;     
MyDataGrid.DataBind(); 

}