datagrid控件与数据库件进行绑定

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

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

            // 数据库连接字符串
            string connectionString = "your_connection_string_here";

            // 查询语句
            string query = "SELECT * FROM YourTable";

            // 创建 SqlConnection 对象
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                // 创建 SqlCommand 对象
                using (SqlCommand command = new SqlCommand(query, connection))
                {
                    // 创建 SqlDataAdapter 对象
                    using (SqlDataAdapter adapter = new SqlDataAdapter(command))
                    {
                        // 创建 DataTable 对象
                        DataTable dataTable = new DataTable();

                        // 填充 DataTable
                        adapter.Fill(dataTable);

                        // 将 DataTable 绑定到 DataGridView 控件
                        dataGridView1.DataSource = dataTable;
                    }
                }
            }
        }
    }
}