使用Dapper结果进行DataGridVew排序

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Windows.Forms;
using Dapper;

namespace YourNamespace
{
    public partial class YourForm : Form
    {
        private string connectionString = "YourConnectionString"; // 替换为实际的数据库连接字符串

        public YourForm()
        {
            InitializeComponent();
        }

        private void YourForm_Load(object sender, EventArgs e)
        {
            // 创建数据库连接对象
            using (var connection = new SqlConnection(connectionString))
            {
                // 构建查询语句
                string query = "SELECT * FROM YourTable";

                // 执行查询并映射结果到.NET对象列表
                List<YourObject> data = connection.Query<YourObject>(query).ToList();

                // 对查询结果进行排序
                data = data.OrderBy(x => x.YourProperty).ToList(); // 根据YourProperty字段升序排序

                // 将排序后的结果绑定到DataGridVew控件
                dataGridView.DataSource = data;
            }
        }
    }

    public class YourObject
    {
        public int Id { get; set; }
        public string YourProperty { get; set; }
        // 其他属性...
    }
}