string connStr = "Server=localhost ;database= northwind ;uid=sa ;pwd=123456;";
string selectCmd = "select * from categories";
SqlConnection myConnection;
myConnection = new SqlConnection(connStr);
SqlDataAdapter myAdapter = new SqlDataAdapter();
DataSet myDs = new DataSet();
myConnection.Open();
myAdapter = new SqlDataAdapter(selectCmd, myConnection);
myAdapter.Fill(myDs, "cate");
dataGrid1.DataSource = myDs;
dataGrid1.DataMember = "cate";
myConnection.Close();
调试结果数据库不能登陆
但是如果:
string connStr = "Server=127.0.0.1 ;database= northwind ;uid=sa ;pwd=123456;";
dataGrid1绑定成功, 调试成功
这是为什么?
string selectCmd = "select * from categories";
SqlConnection myConnection;
myConnection = new SqlConnection(connStr);
SqlDataAdapter myAdapter = new SqlDataAdapter();
DataSet myDs = new DataSet();
myConnection.Open();
myAdapter = new SqlDataAdapter(selectCmd, myConnection);
myAdapter.Fill(myDs, "cate");
dataGrid1.DataSource = myDs;
dataGrid1.DataMember = "cate";
myConnection.Close();
调试结果数据库不能登陆
但是如果:
string connStr = "Server=127.0.0.1 ;database= northwind ;uid=sa ;pwd=123456;";
dataGrid1绑定成功, 调试成功
这是为什么?
Server=(local)
无法连上可能是你host里面localhost未定义或者已经指向其它IP了。
Server=(local)或Server=127.0.0.1或Data Source=(local)或Data Source=127.0.0.1
Server=localhost 改成
Server=(local)
有效
但还是不知道原因?2:
host中:
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host127.0.0.1 localhost
已经指定localhost对应127.0.0.1
所以现在网格的绑定也无法用控件进行设置了
我用“工具箱”->“数据”->控件"SqlDataAdapter" 进行设置,在“新建连接”->“服务器”中无论写127.0.0.1还是192.168.0.2还是. 还是(local), 出错的效果如同server=localhost
所以现在网格的绑定也无法用控件进行设置了