using System.ComponentModel;
 
namespace DapperForm
{
    public class movie
    {
        [DisplayName("電影序號(hào)")]
        public int MovieId { get; set; }
        [DisplayName("電影名稱")]
        public string Name { get; set; }
        [DisplayName("發(fā)行年份")]
        public string Year { get; set; }
        [DisplayName("電影評(píng)級(jí)")]
        public int Rating { get; set; }
    }
}

        private void simpleButton1_Click(object sender, EventArgs e)
        {
            using (var conn = new SqlConnection(connStr))
            {
                conn.Open(); // 打開數(shù)據(jù)庫(kù)連接
                var query = @"SELECT * FROM Movies"; // SQL查詢語(yǔ)句
                var result = conn.Query<movie>(query); // 執(zhí)行查詢操作并將結(jié)果存儲(chǔ)在result變量中
                gridControl1.DataSource = result;
            }
        }

using System;
using System.Windows.Forms;
using DevExpress.XtraEditors;
using System.Data.SqlClient;
using Dapper;
namespace DapperForm
{
    public partial class Form1 : XtraForm
    {
        public string connStr = "Server=.;Database=Movies;User Id=sa;Password=caifox"; // 設(shè)置數(shù)據(jù)庫(kù)連接字符串
        public Form1()
        {
            InitializeComponent();
        }
 
        private void simpleButton1_Click(object sender, EventArgs e)
        {
            using (var conn = new SqlConnection(connStr))
            {
                conn.Open(); // 打開數(shù)據(jù)庫(kù)連接
                var query = @"SELECT * FROM Movies"; // SQL查詢語(yǔ)句
                var result = conn.Query<movie>(query); // 執(zhí)行查詢操作并將結(jié)果存儲(chǔ)在result變量中
                gridControl1.DataSource = result;
            }
        }
    }
}