GridControl使用方法片段

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

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值