c# mysql判断连接状态_【C# MySQL】如何检查MySQL的connector/net连接是否成功

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using MySql.Data.MySqlClient;

namespace MySQLConnection

{

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

string connStr = "server=127.1.1.1;user=root;database=PICSDic;port=3306;password=******;";

MySqlConnection conn = new MySqlConnection(connStr);

try

{

Label1.Text = "Connecting to MySQL...";

conn.Open();

// Perform database operations

}

catch (Exception ex)

{

Label1.Text = ex.ToString();

}

conn.Close();

Label2.Text = "Done.";

}