当前位置: 代码迷 >> ASP.NET >> asp.net数据库的连接有关问题
  详细解决方案

asp.net数据库的连接有关问题

热度:5992   发布时间:2013-02-26 00:00:00.0
asp.net数据库的连接问题
窗体上只有一个DataGrid和SqlConnection控件,所添加代码如下
       private   void   Page_Load(object   sender,   System.EventArgs   e)
{
BindDataGrid();
}
       private   void   BindDataGrid()
{
sqlConnection1.Open();
SqlCommand   sqlCommand   =   new   SqlCommand();
sqlCommand.CommandText   =   "select   FirstName,LastName, "+
"Title,Extension   from   Employees ";
sqlCommand.Connection   =   sqlConnection1;
SqlDataReader   sqlDataReader   =   sqlCommand.ExecuteReader();
DataGrid1.DataSource   =   sqlDataReader;
DataGrid1.DataBind();
sqlConnection1.Close();
}
运行后显示服务器连接不上:sqlConnection1.Open();行有错

------解决方案--------------------------------------------------------
sqlConnection sqlConnection1=new sqlConnection( "server=.;database=news;uid=sa;pwd=; ");
sqlConnection1.Open();
  相关解决方案