GridControl使用方法片段

来源：互联网发布：淘宝客鹊桥怎么搜索编辑：程序博客网时间：2024/06/07 07:25

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 CustomerID,CompanyName,ContactName,ContactTitle From Customers");

           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 = "联系人";
           gridView1.Columns[3].Caption = "联系内容";

          //设置列的名称，便于进行分组和Foot的统计等信息显示
            gridView1.Columns[0].Name = "CustomerID";

           //增加一个Group列进行分组
            this.gridView1.GroupSummary.AddRange(new DevExpress.XtraGrid.GridSummaryItem[] {
            new DevExpress.XtraGrid.GridGroupSummaryItem(DevExpress.Data.SummaryItemType.Count, "CustomerID", null, "(Count={0})")});
        }

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的统计等信息显示
            gridView1.Columns[0].Name = "ID";
            gridView1.Columns[1].Name = "Name";
            gridView1.Columns[2].Name = "Age";

           //增加一个Group列进行分组
            this.gridView1.GroupSummary.AddRange(new DevExpress.XtraGrid.GridSummaryItem[] {
            new DevExpress.XtraGrid.GridGroupSummaryItem(DevExpress.Data.SummaryItemType.Count, "ID", null, "(Count={0})")});

            //增加一个Group列进行分组
            this.gridView1.GroupSummary.AddRange(new DevExpress.XtraGrid.GridSummaryItem[] {
            new DevExpress.XtraGrid.GridGroupSummaryItem(DevExpress.Data.SummaryItemType.Max , "Age", null, "(Max={0})")});


            //设置并制作Foot下面的统计信息
            this.gridView1.GroupFooterShowMode = DevExpress.XtraGrid.Views.Grid.GroupFooterShowMode.VisibleAlways;

            this.gridView1.OptionsView.ShowFooter = true;


            gridView1.Columns[2].SummaryItem.DisplayFormat = "(Age={0})";
            gridView1.Columns[2].SummaryItem.FieldName = "Age";
            gridView1.Columns[2].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;

        }

        //设置成cardview格式
        private void menuItem2_Click(object sender, EventArgs e)
        {
            gridControl1.MainView = this.cardView1;
        }
        //设置成GridView格式
        private void menuItem4_Click(object sender, EventArgs e)
        {
            gridControl1.MainView = this.gridView1 ;
        }