c# - ASP.NET (C#) 查询 MYSQL 无响应，永远等待 localhost

Question

我用ASP.NET查询MYSQL数据库

但是他没有出现。只有"waiting for localhost'我等了，但是没变

但是同样的代码形式是可行的

---ASP.NET

protected void Button3_Click(object sender, EventArgs e)
{
    string connStr = "server=localhost;port=3306;uid=root;pwd=123123;database=testdb;";
    MySqlConnection conn = new MySqlConnection(connStr);
    MySqlCommand command = conn.CreateCommand();
    try
    {
        conn.Open();
        String cmdText = "SELECT NAME FROM playdata WHERE SID = '001'";
        command = new MySqlCommand(cmdText, conn);
        SL1.Text = (string)command.ExecuteScalar();
    }
    catch (MySql.Data.MySqlClient.MySqlException ex)
    {
        switch (ex.Number)
        {
            case 0:
                SL1.Text = "Can not connect";
                break;
            case 1045:
                SL1.Text = "Input error";
                break;
        }
    }
    Console.ReadLine();
    conn.Close();
}

---

不知如何解决，在ASP.NET中插入数据成功所以不知道哪里错了

---插入数据

    string connStr = "server=localhost;port=3306;uid=root;pwd=123123;database=testdb;";
    MySqlConnection conn = new MySqlConnection(connStr);
    MySqlCommand command = conn.CreateCommand();
    try
    {
        conn.Open();
        command.CommandText = "INSERT INTO `testdb`.`playdata` (`SID`, `NAME`,`PWD`,`EMAIL`) VALUES('S01', 'MYNAME','RRR01','E4913')"; //重點
        command.ExecuteNonQuery();
    }
    catch (MySql.Data.MySqlClient.MySqlException ex)
    {
        switch (ex.Number)
        {
            case 0:
                SL1.Text ="Connection fail";
                break;
            case 1045:
                SL1.Text ="pwd error.";
                break;
        }
    }
    Console.ReadLine();
    conn.Close();

---

*编辑我使用 visual studio community 2015我努力了127.0.0.1本地主机String cmdText = "SELECT NAME FROM playdata WHERE SID = '001'";String cmdText = "SELECT NAME FROMtestdb.playdata WHERE SID = '001' ";String cmdText = "SELECT NAME FROM playdata WHERE SID = '001'";

Answer 1

将查询更新为:

String cmdText = "SELECT NAME FROM playdata WHERE SID = 'S01'";

您插入了 SID“S01”并且之前查询的是 SID“001”