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"