Infragistics NetAdvantage UltraGrid的使用

术语：

persist——持续化（保存）property——属性

attribute 特性setting——设置Band——数据条带

一、UltraGrid 的基本概念

UltraGrid的属性设计和一般的控件颇为不同。理解其设计思想，有助于你从其浩瀚的属性中快速找到你所需要的东西。在此文中WinGrid, UltraGrid, UltraWinGrid 是同一个东西。

WinGrid

是一个可展示层级数据的网格控件

数据源实现IList 或ITypedList 接口就可以展示（但不一定可以增删）

可展现具有层级关系的数据，如customers - orders - order details

WinGrid 功能：

·排序

·过滤

·统计

·行列大小调整

·冻结列和冻结行

·列托拽调整位置

·列互换位置

·分割视图

· Outlook风格的BroupBy功能（用户可将列拖到分组栏中对数据进行分组）

·卡片视图

·数据行的自定义布局

·单元格可使用多种编辑控件

·导出到Excel

·打印

·其它Infragistics Presentation Layer Framework 的公共特性，如：Apperances, DrawFilters, CreationFilters

WinGrid 数据条带和层级数据

UltraGrid 可表现具有层级关系的数据

每个层级的数据用一个band（数据条带）来描述

每个band 具有若干的column 和row，类似DataTable

层级间的关系用外键关联来描述

WinGrid 的外观样式方案

（1）使用Appearance 对象控制控件的外观和样式

设置WinGrid 控件的外观

·并不直接设置其字体背景颜色等属性

·而是创建或者选择现有的Appearance 对象（类似Web的css class样式）

·该Appearance 对象拥有多种格式相关的属性，如对齐方式、字体、颜色、图像和alpha融合信息

该方式有以下好处：

·缩减了代码的数量

·便于控制统一的外观，只需要改Appearance 对象就可以了

·对于Grid 这样具有众多子元素的控件，使用此方式设置外观可有效减少内存消耗

（2）其布局和外观是可持续化保存的

UltraGrid.DisplayLayout 属性（UltraGridLayout类）作为所有可持续化保存的特性和对象的容器

调用该对象的Load(), Save(), LoadFromXml(), SaveAsXml() 函数可存取外观控制

由于大部分UltraGrid的设置都可以持续化，所以大部分的功能都是通过UltraGridLayout对象进行设置的

（3）样式是可从上级控件继承和重载的

若控件设置其Appearance 为Default，该控件将会继承其父控件的样式设置（而不是什么缺省值）

如缺省状态下，cell 使用row的背景色，而row使用band的背景色

Band 对象默认继承上级对象的样式，而使用Override 属性（UltraGridOverride 类）来设置其特殊属性

WinGrid 决定绘制一个对象的外观和行为时

·先检查该对象的Override属性

·若该属性内的值被明确修改（非Default），则使用该值

·否则使用上级对象相应的值（Default）

大部分的属性即可以直接在WinGrid设置，也可以在Band设置，后者会覆盖前者// 例：默认只能单行选择，而orders band 允许选择多行

using Infragistics.Win.UltraWinGrid;

UltraGrid1.DisplayLayout.Override.SelectTypeRow = SelectType.Single;

UltraGrid1.DisplayLayout.Bands["Orders"].Override.SelectTypeRow = SelectType.Extended;

卡片视图（Card View）

每条记录用一张卡片来展示，类似表单视图

卡片视图的限制

只能展现最底层的band数据，无法再展示其子层的数据

无法增加新记录？

设置方法

grid.Band[0].CardView = true;

grid.Band[0].CardSettings..... 样式设置

分组视图（GroupBy View）

类似outlook 2007，可将列拖到分组栏中，让数据分组展示

操作方法：

grid.DisplayLayout.ViewStyleBand = ViewStyleBand.OutlookGroupBy;

二、UltraGrid 设计器操作

UltraWinGrid Designer（UltraGrid设计器项目）

Basic Settings :

Data Schema : 设置绑定列的数据格式

Presets : 从预设中选择一个样式，有三种类型：（1）仅与外观相关;（2）仅与行为相关；（3）两者都有

Manage Presets : 预设管理和设置

Feature Picker : 配置功能。详见后

Appearance Browser : 定制的一些外观样式

Band and Column Settings : 要展示数据集和列设置

Band[0] - 'Band 0' :

Columns : 展示列设置：Data Schema中定义绑定列，非绑定列

Column Arrangement Overview : 列展示位置设置（类似报表设计器）Column Arrangement Designer : 分两种：Row layout（可用于复杂表头设置）, Group and levels

Control Settings : 控件所有的属性设置。其实上面的所有设置都可以在这里找到，只是层次深不易找。详见下。

Feature Picker（UltraGrid功能设置）

AutoFit Style : 列自动适应宽度

CardView : 卡片视图

Column Moving : 列是否可拖动位置

Column Sizing : 列调整宽度的方式

Column Swapping : 是否允许列交换位置

Empty Rows : 是否展示空行，空行的样式

Filtering : 列过滤器

Fixed Headers : 冻结列

Fixed Rows : 冻结行

Header Click Sort Action : 标题列点击排序方式：单列排序&多列方式

IDataErrorInfo Support : 数据错误验证方式

Merged Cell : ？合并单元格

Outlook Group By : Outlook Group 风格（可由用户定制数据分组）

Row Selectors : 行选择符号（一个小箭头）

Row Siziing : 行调整高度的方式

Scrolling : 滚动条样式

Selection : 行列单元格选择方式

Summaries : 统计单元格

Updating : 是否允许数据行增删改

Control Setting（UltraGrid控件设置·特有属性）

Appearance

Behavior

Data

Design

Layout

DiaplayLayout

AddNewBox

AutoFitStyle

Bands

EnmptyRowSettings

Override

AllowAddNew

AllowDelete

AllowUpdate

RowSizing

ViewStyle : SingleBand | MultiBand

杂项

常用操作

添加Column: Start/Basic Settings/Data Schema/Manually Define a Schema/添加Column，命名用数据库中的字段名。

添加Column Title: Band and Column Settings/Band [0]（手动添加Column后）/Columns/选择列/Header/修改Caption属性

排序：Picker/Filtring/Allow

分组：Picker/OutLook GroupBy/Active

编辑：Picker/Update

多行表头：Column Arrangement Designer/Add Group/Add Level/把相应的列拖到组下面，

隐藏列：Column Arrangement Designer/Show Hide

单列不可编辑：Band[0]/Column/cellactivation 设置成NoEdit

单击单元格选择状态：Band[0]/Column/CellClickAction

单元格编辑控件：Band[0]/Column/EditorControl

单元格合并：Band[0]/Column/MergedCell。。。

冻结列：Picker/Fixed Header

三、UltraGrid 外观控制

■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■

■■Grid ■■

■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■

动态转载样式文件

this.ultraGrid1.ApplyPresetFromXml(@"C:/Program Files/Common

Files/Infragistics" +

@"/Presets/Win/UltraGridBase/Standard/FlatGreen.xml", true);

存取布局文件（可用这玩意设计报表，动态载入）

this.ultraGrid1.DisplayLayout.SaveAsXml("WinGridLayout.xml");

this.ultraGrid1.DisplayLayout.LoadFromXml(https://www.360docs.net/doc/a912853949.html,bine(Applicati on.StartupPath,

@"https://www.360docs.net/doc/a912853949.html,/ExtraFiles/WinGridLayout.xml"));

使用Appearance（类似预定义的样式）

this.ultraGrid1.DisplayLayout.Appearances.Add("Highlighted" );

this.ultraGrid1.DisplayLayout.Appearances["Highlighted" ].BackColor = Color.Red;

this.ultraGrid1.DisplayLayout.Appearances["Highlighted" ].BackColor = Color.White;

或者直接给预设Appearance赋值

this.ultraGrid1.DisplayLayout.Override.ActiveRowAppearance.ForeColor = Color.White;

使用操作系统样式

https://www.360docs.net/doc/a912853949.html,eOsThemes = DefaultableBoolean.True;

HotTrack

this.ultraGrid1.DisplayLayout.Override.HotTrackCellAppearance.BackColor = Color.Blue;

this.ultraGrid1.DisplayLayout.Override.HotTrackRowCellAppearance.BackColor =

Color.Yellow;

this.ultraGrid1.DisplayLayout.Override.HotTrackHeaderAppearance.BackColor =

Color.Blue;

this.ultraGrid1.DisplayLayout.Override.HotTrackRowAppearance.ForeColor =

Color.LightGreen;

this.ultraGrid1.DisplayLayout.Override.HotTrackRowSelectorAppearance.BackCol or =

Color.Green;

分割滚动视图

设置分割视图（创建SplitBar）

this.ultraGrid1.DisplayLayout.ColScrollRegions[0].Split(0);

this.ultraGrid1.DisplayLayout.RowScrollRegions[0].Split(200);

取消分割视图

this.ultraGrid1.DisplayLayout.MaxColScrollRegions = 1;

this.ultraGrid1.DisplayLayout.MaxRowScrollRegions = 1;

修改Tab键功能

this.ultraGrid1.DisplayLayout.TabNavigation = TabNavigation.NextControl;

TabletPC Ink-Enable

将UltraInkProvider 组件拖到窗体上就可以了

编辑状态的输入框右侧会显示一个小笔按钮，点击后就会弹出手写输入框

若要在非TabletPC上使用该功能，需要安装TabletPC SDK

定义和应用外观样式

this.ultraGrid1.DisplayLayout.Appearances.Add("Highlighted");

this.ultraGrid1.DisplayLayout.Appearances["Highlighted"].BackColor =

Color.Red;

this.ultraGrid1.DisplayLayout.Appearances["Highlighted"].BackColor =

Color.White;

this.ultraGrid1.DisplayLayout.Override.ActiveRowAppearance =

this.ultraGrid1.DisplayLayout.Appearances["Highlighted"];

this.ultraGrid1.DisplayLayout.Override.RowSelectorAppearance =

this.ultraGrid1.DisplayLayout.Appearances["Highlighted"];

--------------------------

this.ultraGrid1.DisplayLayout.Override.ActiveRowAppearance.BackColor = Color.Red;

this.ultraGrid1.DisplayLayout.Override.ActiveRowAppearance.ForeColor = Color.White;

this.ultraGrid1.DisplayLayout.Override.RowSelectorAppearance.BackColor = Color.Red;

this.ultraGrid1.DisplayLayout.Override.RowSelectorAppearance.ForeColor = Color.White;

GroupBy 视图

this.ultraGrid1.DisplayLayout.ViewStyleBand = ViewStyleBand.OutlookGroupBy; this.ultraGrid1.DisplayLayout.Bands[0].SortedColumns.Add("Country", false, true);

this.ultraGrid1.DisplayLayout.Bands[0].SortedColumns.Add("City", false, true);

-------------------------------------------------------

this.ultraGrid1.DisplayLayout.ViewStyleBand = ViewStyleBand.OutlookGroupBy;

this.ultraGrid1.DisplayLayout.GroupByBox.Style = https://www.360docs.net/doc/a912853949.html,pact;

this.ultraGrid1.DisplayLayout.GroupByBox.Appearance.BackColor =

Color.White;

this.ultraGrid1.DisplayLayout.GroupByBox.Prompt = "Drag and drop a column to group by

that column.";

this.ultraGrid1.DisplayLayout.GroupByBox.PromptAppearance.ForeColor = Color.Maroon;

this.ultraGrid1.DisplayLayout.GroupByBox.BorderStyle = UIElementBorderStyle.InsetSoft;

this.ultraGrid1.DisplayLayout.GroupByBox.ButtonBorderStyle =

UIElementBorderStyle.RaisedSoft;

this.ultraGrid1.DisplayLayout.GroupByBox.ShowBandLabels = ShowBandLabels.All;

this.ultraGrid1.DisplayLayout.GroupByBox.BandLabelBorderStyle =

UIElementBorderStyle.Solid;

this.ultraGrid1.DisplayLayout.GroupByBox.BandLabelAppearance.BackColor = Color.DarkBlue;

this.ultraGrid1.DisplayLayout.GroupByBox.BandLabelAppearance.ForeColor =

Color.LightYellow;

this.ultraGrid1.DisplayLayout.GroupByBox.ButtonConnectorStyle =

UIElementBorderStyle.Dotted;

this.ultraGrid1.DisplayLayout.GroupByBox.ButtonConnectorColor =

Color.Maroon;

卡片视图

grid.Band[0].CardView = true;

grid.Band[0].CardSettings..... 样式设置

展开所有行（子行）

this.ultraGrid1.Rows.ExpandAll(true);

数据过滤器

示例

https://www.360docs.net/doc/a912853949.html,yout.Override.AllowRowFiltering = DefaultableBoolean.True;

https://www.360docs.net/doc/a912853949.html,yout.Override.RowFilterAction = RowFilterAction.AppearancesOnly;

https://www.360docs.net/doc/a912853949.html,yout.Override.FilteredInCellAppearance.ForeColor = Color.DarkGreen;

https://www.360docs.net/doc/a912853949.html,yout.Override.FilteredOutCellAppearance.ForeColor = Color.DarkRed;

打开过滤器

this.ultraGrid1.DisplayLayout.Override.AllowRowFiltering = DefaultableBoolean.True;

设置过滤器功能

this.ultraGrid1.DisplayLayout.Override.RowFilterMode =

RowFilterMode.AllRowsInBand;

this.ultraGrid1.DisplayLayout.Override.FilterUIType = FilterUIType.FilterRow;

this.ultraGrid1.DisplayLayout.Override.FilterEvaluationTrigger =

FilterEvaluationTrigger.OnLeaveCell;

this.ultraGrid1.DisplayLayout.Override.FilterOperatorDefaultValue =

FilterOperatorDefaultValue.DoesNotContain;

this.ultraGrid1.DisplayLayout.Override.FilterOperandStyle =

FilterOperandStyle.DropDownList;

this.ultraGrid1.DisplayLayout.Override.FilterOperatorLocation =

FilterOperatorLocation.WithOperand;

this.ultraGrid1.DisplayLayout.Override.FilterOperatorDropDownItems =

FilterOperatorDropDownItems.All;

this.ultraGrid1.DisplayLayout.Override.FilterClearButtonLocation =

FilterClearButtonLocation.Row;

this.ultraGrid1.DisplayLayout.Override.FilterRowPrompt = "Click here to filter

rows...";

this.ultraGrid1.DisplayLayout.Bands[0].SpecialRowPromptField = "Address";

the LogicalOperator property of the ColumnFiltersCollection object.

外观

ultraGrid1.DisplayLayout.Override.FilterRowAppearance

ultraGrid1.DisplayLayout.Override.FilterRowAppearanceActive

ultraGrid1.DisplayLayout.Override.FilterCellAppearance

ultraGrid1.DisplayLayout.Override.FilterRowSelectorAppearance 自定义过滤规则

UltraGridBand band = this.ultraGrid1.DisplayLayout.Bands[2];

band.ColumnFilters["Unit Price"].FilterConditions.Clear( );

band.ColumnFilters["Unit Price"].FilterConditions.Add(

FilterComparisionOperator.GreaterThan, 5 );

band.ColumnFilters["Unit Price"].FilterConditions.Add(

FilterComparisionOperator.LessThan, 10 );

band.ColumnFilters["Unit Price"].LogicalOperator = FilterLogicalOperator.And;

数据错误提示

this.ultraGrid1.DisplayLayout.Override.SupportDataErrorInfo =

SupportDataErrorInfo.RowsAndCells;

this.ultraGrid1.DisplayLayout.Bands[0].Columns[0].SupportDataErrorInfo =

DefaultableBoolean.False;

this.ultraGrid1.DisplayLayout.Override.DataErrorCellAppearance.BackColor = Color.Red;

this.ultraGrid1.DisplayLayout.Override.DataErrorRowSelectorAppearance.Back Color =

Color.Red;

this.ultraGrid1.DisplayLayout.Override.DataErrorRowAppearance.BackColor =

Color.LightYellow;

private void ultraGrid1_InitializeRow(object sender, InitializeRowEventArgs e) {

string rowError = "";

string cellError = "";

Object value = e.Row.Cells["Fax"].Value;

// Set the data error if Fax column value is empty

if(DBNull.Value == value)

{

rowError = "Row contains errors.";

cellError = "Fax can not be empty";

}

DataRowView drv = (DataRowView)e.Row.ListObject;

drv.Row.RowError = rowError;

drv.Row.SetColumnError("Fax", cellError);

}

Tooltip

SummarySettings averageSummary =

https://www.360docs.net/doc/a912853949.html,yout.Bands[0].Summaries.Add(

"GradeAverage",

SummaryType.Average,

https://www.360docs.net/doc/a912853949.html,yout.Bands[0].Columns["Grade"] );

averageSummary.SummaryPosition =

https://www.360docs.net/doc/a912853949.html,eSummaryPositionColumn;

averageSummary.SummaryPositionColumn = averageSummary.SourceColumn; averageSummary.DisplayFormat = "Average: {0:.##}";

averageSummary.Band.Override.SummaryFooterCaptionVisible = DefaultableBoolean.False;

averageSummary.Band.Override.BorderStyleSummaryFooter = UIElementBorderStyle.None;

----------------------------------------

SummarySettings summary =

this.ultraGrid1.DisplayLayout.Bands[0].Summaries.Add(

"sum",

SummaryType.Sum,

this.ultraGrid1.DisplayLayout.Bands[0].Columns[0],

https://www.360docs.net/doc/a912853949.html,eSummaryPositionColumn );

summary.ToolTipText = string.Format( "Sum of column {0}.",

summary.SourceColumn.Header.Caption );

this.ultraGrid1.Rows.SummaryValues[ "sum" ].ToolTipText = string.Format( "Sum of

column {0}.", summary.SourceColumn.Header.Caption );

AlphaBend

if(this.chkRowAlpha.Checked == true)

{

this.ultraGrid1.DisplayLayout.Override.RowAppearance.BackColorAlpha =

https://www.360docs.net/doc/a912853949.html,eAlphaLevel;

this.ultraGrid1.DisplayLayout.Override.RowAppearance.AlphaLevel =

short.Parse(this.spnAlphaLevel.Value.ToString());

}

else

{

this.ultraGrid1.DisplayLayout.Override.RowAppearance.BackColorAlpha =

Alpha.Opaque;

this.ultraGrid1.DisplayLayout.Override.RowAppearance.AlphaLevel = 0;

}

------------------------------------------

if (chEnableAlphaBlending.Checked)

{

this.ultraGrid1.DisplayLayout.Appearance.ImageBackground =

Image.FromFile(clsSamplesPath.GraphicsPath +

"//Backgrounds//nasa_saturn_montage.jpg");

this.ultraGrid1.DisplayLayout.Appearance.ImageBackgroundOrigin =

Infragistics.Win.ImageBackgroundOrigin.Form;

this.ultraGrid1.DisplayLayout.Appearance.ImageBackgroundStyle = Infragistics.Win.ImageBackgroundStyle.Tiled;

this.ultraGrid1.AlphaBlendMode = Infragistics.Win.AlphaBlendMode.Optimized;

}

else

{

this.ultraGrid1.AlphaBlendMode = Infragistics.Win.AlphaBlendMode.Disabled; this.ultraGrid1.DisplayLayout.Appearance.ImageBackground = null;

}

显隐标题

if (chShowCaption.Checked == true)

this.ultraGrid1.Text = "UltraWinGrid CardView Sample";

else

this.ultraGrid1.Text = "";

边框显示

ug.DisplayLayout.BorderStyle = Infragistics.Win.UIElementBorderStyle.Solid;

背景色

ug.DisplayLayout.Appearance.BackColor = Color.White;

■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■

■■Band ■■

■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■

设置数据条带退格宽度

this.ultraGrid1.DisplayLayout.Bands[1].Indentation = 100;

■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■

■■Caption ■■

■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■

表格标题(Caption)

this.ultraGrid1.DisplayLayout.CaptionVisible = DefaultableBoolean.True;

标题

ug.DisplayLayout.CaptionAppearance.TextHAlign = Infragistics.Win.HAlign.Left;

ug.DisplayLayout.CaptionAppearance.BackColor = Color.LightSteelBlue;

■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■

■■Head ■■

■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■

控制标题行的位置

// RepeatOnBreak, FixedOnTop, OncePerRowIsland, OncePerGroupedRowIsland

https://www.360docs.net/doc/a912853949.html,yout.Override.HeaderPlacement =

HeaderPlacement.OncePerGroupedRowIsland;

https://www.360docs.net/doc/a912853949.html,yout.Bands[0].Override.HeaderPlacement = HeaderPlacement.FixedOnTop;

标题换行展示

this.ultraGrid1.DisplayLayout.Override.WrapHeaderText = true;

Header置顶不动

设置displaylayout中的stationarymargins

标题行样式

this.ultraGrid1.DisplayLayout.Override.AllowColSizing = AllowColSizing.Free;

this.ultraGrid1.DisplayLayout.Bands[0].HeaderVisible = true;

this.ultraGrid1.DisplayLayout.Bands[1].HeaderVisible = true;

this.ultraGrid1.DisplayLayout.Bands[1].Header.Caption = "Orders";

this.ultraGrid1.DisplayLayout.Bands[0].Indentation = 0;

this.ultraGrid1.DisplayLayout.Bands[1].Indentation = 0;

this.ultraGrid1.DisplayLayout.RowConnectorStyle = RowConnectorStyle.None;

this.ultraGrid1.DisplayLayout.Bands[0].Header.Appearance.ThemedElementAlp ha =

Alpha.Transparent;

this.ultraGrid1.DisplayLayout.Bands[0].Header.Appearance.BackColor =

SystemColors.ActiveCaption;

this.ultraGrid1.DisplayLayout.Bands[0].Header.Appearance.ForeColor =

SystemColors.ActiveCaptionText;

this.ultraGrid1.DisplayLayout.Bands[1].Header.Appearance.ThemedElementAlpha =

Alpha.Transparent;

this.ultraGrid1.DisplayLayout.Bands[1].Header.Appearance.BackColor =

Color.Blue;

this.ultraGrid1.DisplayLayout.Bands[1].Header.Appearance.BackColor2 = Color.Red;

this.ultraGrid1.DisplayLayout.Bands[1].Header.Appearance.ForeColor =

Color.White;

this.ultraGrid1.DisplayLayout.Bands[1].Header.Appearance.BackGradientStyle = GradientStyle.Horizontal;

隐藏标题行

this.UltraGrid1.Text = "";

■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■

■■Row ■■

■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■

行选择方式

https://www.360docs.net/doc/a912853949.html,yout.Override.SelectTypeRow = SelectType.Single;

e.DisplayLayout.Bands["Orders"].Override.SelectTypeRow =

SelectType.Extended;

https://www.360docs.net/doc/a912853949.html,yout.Override.CellClickAction = CellClickAction.RowSelect;

选择行样式

ug.DisplayLayout.Override.SelectedRowAppearance.BackColor =

Color.SteelBlue;

交错行样式

this.ultraGrid1.DisplayLayout.Override.RowAlternateAppearance.BackColor = Color.Red;

激活行样式

this.ultraGrid1.DisplayLayout.Override.ActiveRowAppearance.BackColor = Color.Red;

ug.DisplayLayout.Override.ActiveRowAppearance.BackColor = Color.SteelBlue;

添加行操作提示

private void ultraGrid1_InitializeLayout(object sender, InitializeLayoutEventArgs e)

{

this.ultraGrid1.DisplayLayout.Bands[0].AutoPreviewEnabled = true;

}

private void ultraGrid1_InitializeRow(object sender, InitializeRowEventArgs e) {

e.Row.Description = "Row Description";

}

private void ultraGrid1_AfterRowInsert(object sender, RowEventArgs e)

{

this.ultraGrid1.DisplayLayout.ActiveRow.Description =

"Data changed in this row will not be added to the database" +

" until you press the Update button.";

}

行渐变背景

UltraGridRow objRow = this.ultraGrid1.Rows[10];

this.ultraGrid1.ActiveRow = objRow;

this.ultraGrid1.Rows[10].Appearance.BackColor2 = Color.Blue;

this.ultraGrid1.Rows[10].Appearance.BackGradientStyle = GradientStyle.Circular;

修改特殊行的位置

新增行

this.ultraGrid1.DisplayLayout.Override.AllowAddNew =

AllowAddNew.TemplateOnTop;

this.ultraGrid1.DisplayLayout.Override.SequenceFixedAddRow = 2;

过滤行

this.ultraGrid1.DisplayLayout.Override.AllowRowFiltering = DefaultableBoolean.True;

this.ultraGrid1.DisplayLayout.Override.FilterUIType = FilterUIType.FilterRow;

this.ultraGrid1.DisplayLayout.Override.SequenceFilterRow = 1;

统计行

this.ultraGrid1.DisplayLayout.Override.AllowRowSummaries = AllowRowSummaries.True;

this.ultraGrid1.DisplayLayout.Override.SummaryDisplayArea = SummaryDisplayAreas.Top;

this.ultraGrid1.DisplayLayout.Override.SequenceSummaryRow = 3;

行高度调整

https://www.360docs.net/doc/a912853949.html,yout.Override.DefaultRowHeight = 60;

https://www.360docs.net/doc/a912853949.html,yout.Override.RowSizing = RowSizing.Free;

this.ultraGrid1.DisplayLayout.Override.RowSizing = RowSizing.Free;

行布局（将列分组展示）

ultraGrid1.DisplayLayout.Bands[0].Groups.Add("Name");

ultraGrid1.DisplayLayout.Bands[0].Groups.Add("Address");

ultraGrid1.DisplayLayout.Bands[0].Groups.Add("Phone");

ultraGrid1.DisplayLayout.Bands[0].Columns["CompanyName"].Group =

ultraGrid1.DisplayLayout.Bands[0].Groups["Name"];

ultraGrid1.DisplayLayout.Bands[0].Columns["ContactName"].Group =

ultraGrid1.DisplayLayout.Bands[0].Groups["Name"];

ultraGrid1.DisplayLayout.Bands[0].Columns["ContactTitle"].Group =

ultraGrid1.DisplayLayout.Bands[0].Groups["Name"];

ultraGrid1.DisplayLayout.Bands[0].Columns["CustomerID"].Group =

ultraGrid1.DisplayLayout.Bands[0].Groups["Name"];

ultraGrid1.DisplayLayout.Bands[0].Columns["Address"].Group =

ultraGrid1.DisplayLayout.Bands[0].Groups["Address"];

ultraGrid1.DisplayLayout.Bands[0].Columns["Country"].Group =

ultraGrid1.DisplayLayout.Bands[0].Groups["Address"];

ultraGrid1.DisplayLayout.Bands[0].Columns["City"].Group =

ultraGrid1.DisplayLayout.Bands[0].Groups["Address"];

ultraGrid1.DisplayLayout.Bands[0].Columns["Region"].Group =

ultraGrid1.DisplayLayout.Bands[0].Groups["Address"];

ultraGrid1.DisplayLayout.Bands[0].Columns["PostalCode"].Group =

ultraGrid1.DisplayLayout.Bands[0].Groups["Address"];

ultraGrid1.DisplayLayout.Bands[0].Columns["Phone"].Group =

ultraGrid1.DisplayLayout.Bands[0].Groups["Phone"];

ultraGrid1.DisplayLayout.Bands[0].Columns["Fax"].Group =

ultraGrid1.DisplayLayout.Bands[0].Groups["Phone"];

ultraGrid1.DisplayLayout.Bands[0].LevelCount = 2;

ultraGrid1.DisplayLayout.Bands[0].Columns["City"].Level = 1;

ultraGrid1.DisplayLayout.Bands[0].Columns["Country"].Level = 1;

ultraGrid1.DisplayLayout.Bands[0].Columns["PostalCode"].Level = 1;

ultraGrid1.DisplayLayout.Bands[0].Columns["Fax"].Level = 1;

冻结行

this.ultraGrid1.DisplayLayout.Override.FixedRowStyle = FixedRowStyle.Top;

this.ultraGrid1.Rows.FixedRows.Add(this.ultraGrid1.Rows[0]);

this.ultraGrid1.Rows[0].Fixed = true;

this.ultraGrid1.DisplayLayout.Override.FixedRowIndicator =

FixedRowIndicator.Button;

FixedRowAppearance

FixedRowCellAppearance

FixedRowSelectorAppearance

统计行

this.ultraGrid1.DisplayLayout.Override.AllowRowSummaries = AllowRowSummaries.True;

this.ultraGrid1.DisplayLayout.Override.SummaryDisplayArea =

SummaryDisplayAreas.GroupByRowsFooter | SummaryDisplayAreas.TopFixed; ------------------------------------------------------

this.ultraGrid1.DisplayLayout.Bands[0].Summaries.Add(

SummaryType.Minimum,

null,

this.ultraGrid1.DisplayLayout.Bands[0].Columns["Country"],

SummaryPosition.Left,

null

);

this.ultraGrid1.DisplayLayout.Bands[0].Summaries[0].SummaryPosition =

SummaryPosition.Center;

this.ultraGrid1.DisplayLayout.Bands[0].SummaryFooterCaption = "My Sums";

行首显示行号(行选择器)

https://www.360docs.net/doc/a912853949.html,yout.Override.RowSelectors = DefaultableBoolean.True;

https://www.360docs.net/doc/a912853949.html,yout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex;

https://www.360docs.net/doc/a912853949.html,yout.Override.RowSelectorWidth = 30;

选中行

this.ultraGrid1.Rows[i].Selected = true;

激活行

this.ultraGrid1.Rows[i].Activate();

this.ultraGrid1.ActiveRow = this.ultraGrid1.Rows[5];

this.ultraGrid1.DisplayLayout.Override.ActiveRowAppearance.BackColor = Color.Aqua;

this.ultraGrid1.ActiveCell = this.ultraGrid1.ActiveRow.Cells["CompanyName"]; 遍历行

// 定位到首行

UltraGridRow aRow = this.ultraGrid1.GetRow(ChildRow.First);

// 搜索后继行

if(aRow.HasNextSibling())

{

UltraGridRow NextRow = aRow.GetSibling(SiblingRow.Next);

MessageBox.Show("Has Siblings");

}

// 搜索子行

if(aRow.HasChild())

{

UltraGridRow childRow =

aRow.GetChild(Infragistics.Win.UltraWinGrid.ChildRow.First);

MessageBox.Show("Has a Child");

}

判断总行数

this.ultraGrid1.Rows.Count

特殊行外观设置

this.ultraGrid1.DisplayLayout.Override.SpecialRowSeparator =

SpecialRowSeparator.FixedRows;

this.ultraGrid1.DisplayLayout.Override.SpecialRowSeparatorHeight = 25;

this.ultraGrid1.DisplayLayout.Override.BorderStyleSpecialRowSeparator = UIElementBorderStyle.Dashed;

隐藏行分隔线

https://www.360docs.net/doc/a912853949.html,yout.Reset();

https://www.360docs.net/doc/a912853949.html,yout.Override.CellAppearance.BorderAlpha = Alpha.Transparent;

https://www.360docs.net/doc/a912853949.html,yout.Override.RowAppearance.BorderColor = Color.White;

■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■

■■Column ■■

■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■

UltraGrid内置支持的列编辑类型

Default 缺省类型

Edit 文本框

EditButton 按钮文本框

CheckBox 复选框

TriStateCheckBox 三态复选框

DropDown 组合框（可编辑）

DropDownList 下拉框（只选）

DropDownValidate 组合框（只可输入列表中的数据）

Button 按钮。点击时触发ClickCellButton 事件

DropDownCalendar 下拉日历控件

Date 日期输入、下拉日历组合控件。可设置MinValue 和MaxValue，并对

输入进行掩码校验

DateWithoutDropDown 日期输入

DateWithSpin 类似Date控件，但用spin按钮取代了下拉日历控件

DateTime 日期时间输入控件

DateTimeWithoutDropDown 日期时间输入控件，但取消了下拉按钮

DateTimeWithSpin 日期时间输入控件，使用spin按钮替代下拉按钮

Color 色彩选择

Currency 金额，可修改MaskInput 属性定制mask

CurrencyNonNegative 金额，不允许负数

CurrencyPositive 金额，只允许正数

Double double。可用NumberFormatInfo 设置掩码，用MinValue MaxValue

限制范围

DoubleWithSpin double + spin

DoubleNonNegative double 非负

DoubleNonNegativeWithSpin double 非负spin

DoublePositive double 正数

DoublePositiveWithSpin double 正数spin

Font 字体选择框

Image 图像展示（EmbeddableImageRenderer）

ImageWithShadow 图像，阴影效果

Integer 整数

IntegerWithSpin 整数，spin

IntegerPositive 整数，正数

IntegerPositiveWithSpin 整数，正数，spin

IntegerNonNegative 整数，非负

IntegerNonNegativeWithSpin 整数，非负，spin

Time 时间（可用MaskInput 设置掩码，用Minimum 和maximum 设置范围

）

TimeWithSpin 时间，spin

TimeZone 时区

URL URL（FormattedLinkEditor）

FormattedText 带格式的文本（FormattedLinkEditor）

设置列编辑类型示例

button

this.ultraGrid1.DisplayLayout.Bands[0].Columns[0].Style =

ColumnStyle.Button;

checkbox

this.ultraGrid1.DisplayLayout.Bands[0].Columns.Add("CheckBoxColumn");

this.ultraGrid1.DisplayLayout.Bands[0].Columns["CheckBoxColumn"].DataT ype = typeof

(bool);

this.ultraGrid1.DisplayLayout.Bands[0].Columns["CheckBoxColumn"].Style =

ColumnStyle.CheckBox;

dropdownlist

this.ultraGrid1.DisplayLayout.ValueLists.Add("List1");

this.ultraGrid1.DisplayLayout.ValueLists["List1"].ValueListItems.Add(1, "One");

this.ultraGrid1.DisplayLayout.ValueLists["List1"].ValueListItems.Add(2, "Two");

this.ultraGrid1.DisplayLayout.ValueLists["List1"].ValueListItems.Add(3, "Three");

this.ultraGrid1.DisplayLayout.ValueLists["List1"].DisplayStyle =

ValueListDisplayStyle.DisplayText;

this.ultraGrid1.DisplayLayout.Bands[0].Columns[2].Style =

ColumnStyle.DropDownList;

this.ultraGrid1.DisplayLayout.Bands[0].Columns[2].ValueList =

this.ultraGrid1.DisplayLayout.ValueLists["List1"];

手工设置单元格编辑控件

EmbeddableEditorBase editor = null;

DefaultEditorOwnerSettings editorSettings = new DefaultEditorOwnerSettings( );

---------------------------------------

EditorWithText

editorSettings.DataType = typeof( string );

editor = new EditorWithText( new DefaultEditorOwner( editorSettings ) );

ColorPickerEditor

editorSettings.DataType = typeof( Color );

editor = new ColorPickerEditor( new DefaultEditorOwner( editorSettings ) );

FontNameEditor

valueList = new ValueList( );

editorSettings.DataType = typeof( string );

for ( int i = 0; i < System.Drawing.FontFamily.Families.Length; i++ )

valueList.ValueListItems.Add( System.Drawing.FontFamily.Families[i].Name );

editorSettings.ValueList = valueList;

editor = new FontNameEditor( new DefaultEditorOwner( editorSettings ) );

---------------------------------------

EditorWithMarsk (Currency)

editorSettings.DataType = typeof( decimal );