AstrixGame
New member
- Joined
- Aug 11, 2021
- Messages
- 4
- Programming Experience
- 5-10
Hi I am creating a project in .net and I am getting data from mysql but mysql connection is reporting the error "System.InvalidOperationException: Connection must be valid and open." My program:
C#:
private void Form1_Load(object sender, EventArgs e)
{
string command = "SELECT coins from users WHERE nick = " + textBox1.Text;
MySqlConnection dbconn = new MySqlConnection("SERVER=sql4.freemysqlhosting.net;PORT=3306;DATABASE=sql4429796;UID=sql4429796;PWD=************;");
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(command, dbconn);
dbconn.Open();
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
coins = dataReader["coins"].ToString();
}
}
}
Last edited: