gridcontrol使用

来源:百度知道 编辑:UC知道 时间:2024/05/30 18:08:58

private void mnuLoad_Click(object sender, System.EventArgs e)
{
// TODO: Load Customers

Database db = null;
db = DatabaseFactory.CreateDatabase();

DataSet ds = db.ExecuteDataSet(
CommandType.Text,
"SELECT ID,Name,Age From UserInfo");

gridControl1.DataSource = ds.Tables[0];

//设置成一次选择一行,并且不能被编辑
this.gridView1.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFocus;
this.gridView1.OptionsBehavior.Editable = false;
this.gridView1.OptionsSelection.EnableAppearanceFocusedCell = false;

//设置列的标题
gridView1.Columns[0].Caption = "编号";
gridView1.Columns[1].Caption = "名称";
gridView1.Columns[2].Caption = "年龄";

//设置列的名称,便于进行分组和Foot