DevExpress数据绑定呈现

using System;
using System.Data;
using System.Data.SqlClient;

namespace DXApplication6
{
    public partial class Form1 : DevExpress.XtraEditors.XtraForm
    {
        public Form1()
        {
            InitializeComponent();
        }
        public DataTable GetDataTable()
        {
            string strCon = "Data Source=.;Initial Catalog=test_10_23;User ID=sa;Password=123456;Connection Timeout=10";
            string sql = "select * from emp";
            SqlDataAdapter sda = new SqlDataAdapter(sql, strCon);
            DataTable dt = new DataTable();
            sda.Fill(dt);
            return dt;
        }

        private void gridControl1_Load(object sender, EventArgs e)
        {
            this.gridControl1.DataSource = GetDataTable();
        }
        /// <summary>
        /// 从数据库里获取数据之后呈现到列表里得单元格时候所触发的事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void gridView1_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
        {
            if (e.Column.Caption == "补贴")
            {
                string strValue = e.Value.ToString();
                if (strValue == "")//数据库中补贴为空时，显示0
                {
                    e.DisplayText = "0";
                }
            }
        }
        /// <summary>
        /// 表示每行生成的时候随绘制这一行数据的时候触发
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void gridView1_CustomDrawRowIndicator(object sender, DevExpress.XtraGrid.Views.Grid.RowIndicatorCustomDrawEventArgs e)
        {
            if(e.Info.IsRowIndicator && e.RowHandle >= 0)//在表格前面加行号
            {
                e.Info.DisplayText = (e.RowHandle + 1).ToString();
            }
        }
    }
}