如何在c#中实现数据库访问与DatagridView的自动同步

string connectionString = "server=数据库服务器地址;user=用户名;password=密码;database=数据库名;";
MySqlConnection connection = new MySqlConnection(connectionString);

string sql = "SELECT * FROM 表名;";
MySqlCommand command = new MySqlCommand(sql, connection);
MySqlDataAdapter adapter = new MySqlDataAdapter(command);
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);

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

namespace DatabaseSyncExample
{
    public partial class Form1 : Form
    {
        private MySqlConnection connection;
        private DataTable dataTable;

        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            string connectionString = "server=数据库服务器地址;user=用户名;password=密码;database=数据库名;";
            connection = new MySqlConnection(connectionString);
            connection.Open();

            string sql = "SELECT * FROM 表名;";
            MySqlCommand command = new MySqlCommand(sql, connection);
            MySqlDataAdapter adapter = new MySqlDataAdapter(command);
            dataTable = new DataTable();
            adapter.Fill(dataTable);

            dataGridView.DataSource = dataTable;
        }
    }
}