UltraWinGrid使用

1、数据源

   grd.DataSource = myCls.loadGrid2_ds(stj).Tables(0)

     grd.Refresh()

2、显示页脚

           grd.DisplayLayout.Bands(0).SummaryFooterCaption = "总额："
            grd.DisplayLayout.Override.SummaryFooterAppearance.TextHAlign = Infragistics.Win.HAlign.Right
            grd.DisplayLayout.Bands(0).Summaries.Add("C1", Infragistics.Win.UltraWinGrid.SummaryType.Sum, grd.DisplayLayout.Bands(0).Columns("总金额"), Infragistics.Win.UltraWinGrid.SummaryPosition.UseSummaryPositionColumn)
            grd.DisplayLayout.Bands(0).Summaries("C1").DisplayFormat = "{0:C1}"

3、列禁止拖拽
            grd.DisplayLayout.Override.AllowColMoving = Infragistics.Win.UltraWinGrid.AllowColMoving.NotAllowed  '列是否可移动

 4、获取总行数

        SBar.Panels(1).Text = grd.Rows.Count.ToString

5、选择一行后获取一列的值

grd.ActiveRow.Cells(0).Text

6、GRID初始化

grd_InitializeLayouT事件

  '行选择
        e.Layout.Override.SelectTypeRow = Infragistics.Win.UltraWinGrid.SelectType.Single
        '进行行选择
        e.Layout.Override.CellClickAction = Infragistics.Win.UltraWinGrid.CellClickAction.RowSelect

        '支持排序
        e.Layout.ViewStyleBand = Infragistics.Win.UltraWinGrid.ViewStyleBand.Vertical
        e.Layout.Override.HeaderClickAction = Infragistics.Win.UltraWinGrid.HeaderClickAction.SortMulti

7、隐藏某一列

e.Layout.ActiveRow.Cells("编码").Hidden = True

8、时间格式显示长格式

  e.Layout.Bands(0).Columns(1).Format = "F"