MySqlConnection conn = new MySqlConnection("server=127.0.0.1:3306;user=root;password=;database=ecshop");
string mystr = "select * from ecs_user_rank";
MySqlCommand myCommand = new MySqlCommand(mystr, conn);
conn.Open();
myCommand.ExecuteNonQuery();
MySqlDataReader myDataReader = myCommand.ExecuteReader();
string bookres = "";
while (myDataReader.Read() == true)
{
bookres += myDataReader["rank_id"];
bookres += myDataReader["rank_name"];
bookres += myDataReader["show_price"];
}
myDataReader.Close();
conn.Close();
Label1.Text = bookres;这是我的代码,有错误么。报错:System.Net.Sockets.SocketException: 不知道这样的主机。
string mystr = "select * from ecs_user_rank";
MySqlCommand myCommand = new MySqlCommand(mystr, conn);
conn.Open();
myCommand.ExecuteNonQuery();
MySqlDataReader myDataReader = myCommand.ExecuteReader();
string bookres = "";
while (myDataReader.Read() == true)
{
bookres += myDataReader["rank_id"];
bookres += myDataReader["rank_name"];
bookres += myDataReader["show_price"];
}
myDataReader.Close();
conn.Close();
Label1.Text = bookres;这是我的代码,有错误么。报错:System.Net.Sockets.SocketException: 不知道这样的主机。
下载了个MySql.Data.dll。可是总是报错!
MySqlConnection conn = new MySqlConnection("server=127.0.0.1:3306;user=root;password=;database=ecshop");改为:
MySqlConnection conn = new MySqlConnection(@"server=127.0.0.1:3306;user=root;password=;database=ecshop");
加个转义符!
http://www.jb51.net/article/19653.htm
装驱动。
改为下面的试试
server=.;user=root;password=;database=ecshop
server=127.0.0.1;user=root;password=;database=ecshop