How to check MySQL connection state in C#

Viewed 37005

Hi I am connecting to MySQL in C# and I need to check is the SQL connection open or not. If open then do something or if not do something. I am trying by below code but I am getting error.

var sqlCon= new SqlConnection(Properties.Settings.Default.sString);
var mySQLCon= new MySqlConnection(Properties.Settings.Default.dString);
sqlCon.Open();
mySQLCon.Open();
if (sqlCon.State==ConnectionState.Open && mySQLCon.State==ConnectionState.Open)
  {
    MessageBox.Show(@"Connection working.");
  }
else
  {
    MessageBox.Show(@"Please check connection string");
  }

I am getting error on mySQLCon.State==ConnectionState.Open Error is InvalidOperationException How can we check the MySQL connection state.

1 Answers
Related