winform查询mysql数据库连接

using MySql.Data.MySqlClient;

// 建立MySQL数据库连接
string connectionString = "server=localhost;database=mydb;uid=root;pwd=123456;";
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
    try
    {
        connection.Open();  // 打开数据库连接

        // 执行查询语句
        string query = "SELECT * FROM customers";
        MySqlCommand command = new MySqlCommand(query, connection);
        MySqlDataReader reader = command.ExecuteReader();

        // 处理查询结果
        while (reader.Read())
        {
            string name = reader.GetString("name");
            string email = reader.GetString("email");
            // 处理数据...
        }

        reader.Close();  // 关闭数据读取器
    }
    catch (MySqlException ex)
    {
        // 处理数据库异常
        Console.WriteLine("MySQL Error: " + ex.Message);
    }
    finally
    {
        connection.Close();  // 关闭数据库连接
    }
}