C#将mySQL结果添加到组合框

using System;
using System.Windows.Forms;
using MySql.Data.MySqlClient;

namespace WindowsFormsApp
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            // 建立与MySQL数据库的连接
            string connectionString = "server=localhost;user=root;password=123456;database=test;";
            MySqlConnection connection = new MySqlConnection(connectionString);

            try
            {
                // 打开数据库连接
                connection.Open();

                // 编写SQL查询语句
                string query = "SELECT name FROM table_name;";

                // 创建MySQL命令对象
                MySqlCommand command = new MySqlCommand(query, connection);

                // 执行查询语句，获取查询结果
                MySqlDataReader reader = command.ExecuteReader();

                // 将查询结果添加到组合框控件中
                while (reader.Read())
                {
                    comboBox1.Items.Add(reader.GetString(0));
                }

                // 关闭数据阅读器
                reader.Close();
            }
            catch (Exception ex)
            {
                // 处理异常
                MessageBox.Show("Error: " + ex.Message);
            }
            finally
            {
                // 关闭数据库连接
                connection.Close();
            }
        }
    }
}