GridControl使用方法片段

最新推荐文章于 2024-01-16 08:39:36 发布

queatin_man

最新推荐文章于 2024-01-16 08:39:36 发布

阅读量1.3k

点赞数

分类专栏： VC 文章标签： null

VC 专栏收录该内容

3 篇文章

订阅专栏

本文介绍如何从数据库加载客户信息及用户信息到网格视图(grid)，并对网格视图进行详细配置，包括设置不可编辑、调整列标题、实现分组统计等功能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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 ;
        }