DevExpress.XtraGrid.GridControl (表格控件使用说明)

//简单的数据绑定

  private void simpleBtnSearch_Click(object sender, EventArgs e)
        {


            DataTable dt = new DataTable();
            DataColumn dc = new DataColumn("KeyFieldName");
            DataColumn dc3 = new DataColumn("ParentFieldName");
            DataColumn dc2 = new DataColumn("name");
            dt.Columns.Add(dc);
            dt.Columns.Add(dc2);
            dt.Columns.Add(dc3);
            for (int i = 0; i < 100; i++)
            {
                DataRow dr = dt.NewRow();
                dr["KeyFieldName"] = i;
                dr["ParentFieldName"] = (i % 5 == 0 ? "Null" : (i % 5).ToString());
                dr["name"] = i + "haha";
                dt.Rows.Add(dr);
            }
            this.gridControl1.DataSource = dt;
}

/// <summary>
        /// 绑定数据
        /// </summary>
        /// <param name="querydt"></param>
        private void BuildView(DataTable querydt)
        {
            //数据绑定
            this.gridControl1.DataSource = null;
            this.gridControl1.DataSource = querydt;
            this.gridControl1.RefreshDataSource();
            //设置列隐藏
            this.gridView1.Columns["EVID"].Visible = false;
            this.gridView1.Columns["省"].Visible = false;
            this.gridView1.Columns["市"].Visible = false;
            this.gridView1.Columns["县"].Visible = false;
            //设置列不可编辑
            this.gridView1.Columns["项目名称"].OptionsColumn.ReadOnly = false;
            this.gridView1.Columns["发证级别"].OptionsColumn.ReadOnly = false;
            this.gridView1.Columns["海域等别"].OptionsColumn.ReadOnly = false;
            this.gridView1.Columns["项目状态"].OptionsColumn.ReadOnly = false;
            this.gridView1.Columns["项目位置"].OptionsColumn.ReadOnly = false;
            this.gridView1.Columns["用海总面积"].OptionsColumn.ReadOnly = false;
            this.gridView1.Columns["投资总额"].OptionsColumn.ReadOnly = false;
            this.gridView1.Columns["证书数量"].OptionsColumn.ReadOnly = false;
            //统计设计
            this.gridView1.OptionsView.ShowFooter =true;// 统计的类型
            this.gridView1.Columns["用海总面积"].SummaryItem.SummaryType =   DevExpress.Data.SummaryItemType.Sum; // 显示的格式
            this.gridView1.Columns["用海总面积"].SummaryItem.DisplayFormat = "(合计:{0})";
            this.gridView1.Columns["投资总额"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; // 显示的格式
            this.gridView1.Columns["投资总额"].SummaryItem.DisplayFormat = "(合计:{0})";

            //其他一些设置
            //要调整行号列的宽度只需要调整gridview1.IndicatorWidth属性即可
           // gridView1.OptionsView.ColumnAutoWidth = false;//设置不自动出现滚动条
            gridView1.OptionsCustomization.AllowColumnMoving = false; //让各列头禁止移动
            gridView1.OptionsCustomization.AllowSort = false;//让各列头禁止排序
            gridView1.OptionsCustomization.AllowColumnResizing = false;//禁止各列头改变列宽
        }