如何使用combobox从数据库中选择表？

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

public partial class Form1 : Form
{
    private MySqlConnection connection;
    private string connectionString = "server=localhost;user=root;database=mydatabase;password=mypassword";

    public Form1()
    {
        InitializeComponent();
    }

    private void Form1_Load(object sender, EventArgs e)
    {
        // 连接数据库
        connection = new MySqlConnection(connectionString);
        connection.Open();

        // 查询数据库表
        string query = "SELECT table_name FROM information_schema.tables WHERE table_schema = 'mydatabase'";
        MySqlCommand command = new MySqlCommand(query, connection);
        MySqlDataAdapter adapter = new MySqlDataAdapter(command);
        DataTable table = new DataTable();
        adapter.Fill(table);

        // 绑定数据到combobox
        comboBox1.DataSource = table;
        comboBox1.DisplayMember = "table_name";
    }

    private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
    {
        // 处理选择事件
        string selectedTable = comboBox1.Text;
        // 可以根据选择的表名进行相应的操作，例如查询表的结构信息
        // ...
    }
}