怎么判断c#是否连接到mysql数据库

怎么判断c#是否连接到mysql数据库

怎么判断c#是否连接到mysql数据库
可以使用try...catch的检测 举个例子... try
{
SqlConnection conn = new SqlConnection("server=.;database=数据库名;uid=sa;pwd=密码");
conn.Open();
if (ConnectionState.Open==conn.State)
{
MessageBox.Show("数据库已打开");
}
else
{
MessageBox.Show("数据库已关闭");
}
}
catch (Exception ex)
{ MessageBox.Show(ex.Message);
}

这是sqlsever的，不是mysql

string connectionstring = configurationmanager.appsettings["connectionstring"]; string sqlstring="......(此处sql语句省略)"; using (mysqlconnection connection = new mysqlconnection(connectionstring)) { using (mysqlcommand cmd = new mysqlcommand(sqlstring, connection)) { try { connection.open(); int rows = cmd.executenonquery();//执行sql语句 return rows; } catch (mysql.data.mysqlclient.mysqlexception e) { connection.close(); throw e; } } }