一、将数据DataTable列表动态展示
//需要展示的数据列表查询sql
String sql = string.Format("SELECT code 工号,name 姓名 FROM t_user ");
//执行sql获取DataTable
DataTable dt = DataAccess.Access().GetTableBySql(sql);
//将DataTable作为数据源赋值给gridControl1
this.gridControl1.DataSource =dt;
二、设置列表gridView的表头和单元格居中对齐
//获取gridView的列数
int count = this.gridView1.Columns.Count;
//循环列数设置
for (int i = 0; i < count; i++)
{
//设置表头顶点对齐
gridView1.Columns[i].AppearanceHeader.TextOptions.VAlignment = DevExpress.Utils.VertAlignment.Center;
// 设置表头水平对齐
gridView1.Columns[i].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
//设置单元格顶点对齐
gridView1.Columns[i].AppearanceCell.TextOptions.VAlignment = DevExpress.Utils.VertAlignment.Center;
//设置单元格水平对齐
gridView1.Columns[i].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
}
三、设置gridView的可编辑性
//设置整个表不可编辑
this.gridView1.OptionsBehavior.Editable = false;
//设置某列不可编辑 gridColumn为列名
this.gridView1.gridColumn.OptionsColumn.AllowEdit = false;
最新评论