[Solved] How to retrieve data from MySQL DB to GridView in ASP

you did not open your connections. try it by adding this

myconn.open();

before this line

MySqlDataAdapter mydata = new MySqlDataAdapter(strSQL, myconn);