使用线程将数据从SQL Server加载到datagridview

using System;
using System.Data;
using System.Data.SqlClient;
using System.Threading;
using System.Windows.Forms;

namespace WindowsFormsApp
{
    public partial class MainForm : Form
    {
        private Thread loadDataThread;

        public MainForm()
        {
            InitializeComponent();
        }

        private void MainForm_Load(object sender, EventArgs e)
        {
            // 启动后台线程加载数据
            loadDataThread = new Thread(LoadData);
            loadDataThread.Start();
        }

        private void LoadData()
        {
            string connectionString = "your_connection_string";
            string query = "SELECT * FROM your_table";

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                using (SqlCommand command = new SqlCommand(query, connection))
                {
                    connection.Open();

                    DataTable dataTable = new DataTable();
                    SqlDataAdapter dataAdapter = new SqlDataAdapter(command);
                    dataAdapter.Fill(dataTable);

                    // 在主线程中更新DataGridView
                    dataGridView.Invoke(new Action(() =>
                    {
                        dataGridView.DataSource = dataTable;
                    }));
                }
            }
        }

        private void MainForm_FormClosing(object sender, FormClosingEventArgs e)
        {
            // 等待后台线程结束
            loadDataThread.Join();
        }
    }
}