c# - ASP.NET (C #) Query MYSQL No response, Wait for localhost forever -

i use asp.net query mysql database

but did not show. "waiting localhost'i waited, did not change

but same code in form feasible

---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 playdata 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(); } 

---

i not know how solve problem, , in asp.net, insert data successful not know wrong

---insert data

    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 `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(); 

---

*edit use visual studio community 2015 have tried 127.0.0.1 localhost string cmdtext = "select name playdata sid = '001'"; string cmdtext = "select name fromtestdb.playdata sid = '001' "; string cmdtext = "select name playdata sid = '001'";

update query to:

string cmdtext = "select name playdata sid = 's01'"; 

you inserted sid 's01' , querying sid '001'