如何使用select查询中的数据集填充datagridview？

string connectionString = "你的数据库连接字符串";
SqlConnection connection = new SqlConnection(connectionString);

string sqlQuery = "SELECT * FROM YourTableName";

SqlDataAdapter adapter = new SqlDataAdapter(sqlQuery, connection);
DataSet dataSet = new DataSet();
adapter.Fill(dataSet, "YourTableName");

dataGridView1.DataSource = dataSet.Tables["YourTableName"];

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

public partial class MainForm : Form
{
    public MainForm()
    {
        InitializeComponent();
        LoadData();
    }

    private void LoadData()
    {
        string connectionString = "你的数据库连接字符串";
        string sqlQuery = "SELECT * FROM YourTableName";

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            try
            {
                connection.Open();
                SqlDataAdapter adapter = new SqlDataAdapter(sqlQuery, connection);
                DataSet dataSet = new DataSet();
                adapter.Fill(dataSet, "YourTableName");
                dataGridView1.DataSource = dataSet.Tables["YourTableName"];
            }
            catch (Exception ex)
            {
                MessageBox.Show("数据库错误: " + ex.Message);
            }
        }
    }
}