如何检查在C＃MySQL连接状态

问题描述：

你好我连接到MySQL在C＃中，我需要检查的是SQL连接打开与否。如果打开然后做某件事，或者如果没有做一些事情。
我想通过下面的代码，但我得到的错误。

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");
  }

我在 mySQLCon.State得到错误== ConnectionState.Open
错误是出现InvalidOperationException
，我们如何检查MySQL连接状态。

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

答

我认为错误应该在连接字符串。首先检查你的连接字符串。

I think error should be in connection string. Check your connection string first.

如果连接字符串是正确的，有一些另外一个问题你可以试试下面。

if connection string is correct and there is some another issue try something like below.

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

还有一件事是@Leri提到你应该总是关闭/处置非托管资源。
希望它为你工作。

And one more thing as @Leri mentioned you should always close/dispose unmanaged resources. Hope it work for you.

如何检查在C＃MySQL连接状态

相关推荐