asp.net使用mysql数据库连接

<connectionStrings>
  <add name="MySQLConnectionString" connectionString="server=数据库服务器地址;database=数据库名称;uid=用户名;pwd=密码;" providerName="MySql.Data.MySqlClient" />
</connectionStrings>

using System;
using MySql.Data.MySqlClient;

namespace YourNamespace
{
    public class YourClass
    {
        public void ConnectToMySQL()
        {
            string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString;
            MySqlConnection connection = new MySqlConnection(connectionString);

            try
            {
                connection.Open();
                // 连接已打开，可以执行数据库操作

                // 示例：执行一个查询并读取结果
                string query = "SELECT * FROM your_table";
                MySqlCommand command = new MySqlCommand(query, connection);
                MySqlDataReader reader = command.ExecuteReader();
                while (reader.Read())
                {
                    // 读取结果行的数据
                }
                reader.Close();
            }
            catch (MySqlException ex)
            {
                // 处理连接异常
            }
            finally
            {
                connection.Close();
            }
        }
    }
}