VIBlend DataGrid for Silverlight是一款全功能的OLAP grid for Silverlight。它匯集了傳統(tǒng)的數(shù)據(jù)網(wǎng)格控件、分層的網(wǎng)格和類似于Excel透視表格的功能。VIBlend DataGrid for Silverlight支持數(shù)據(jù)綁定和完全無綁定模式。您可以可視化一個數(shù)據(jù)庫表格,綁定到一個通用的集合或通過使用API而不使用任何數(shù)據(jù)源填充一個網(wǎng)格的內容。
VIBlend DataGrid for Silverlight is the first fully functional OLAP grid for Silverlight. It brings together the features of traditional data grid controls, hierarchical grids and Excel-like pivot tables.VIBlend DataGrid for Silverlight supports both data bindings and complete unbound mode. You can visualize a database table, bind to a generic collection or populate the grid's content through APIs without using any datasource.
功能特點及優(yōu)點:
標準功能
在VIBlend DataGrid數(shù)百計的功能中,支持行和列大小調整,可定制的工具提示,單元格樣式,單元格模板和格式化,對列和行的全拖放支持,鍵盤導航,多個單元格選擇,全行/列選擇模式。
就地單元格編輯
從許多可嵌入的單元格編輯器中選擇,這些編輯器包含文本框,復選框,日期選擇器,屏蔽的文本框或您選擇的其他任何自定義的控件。
單元格合并
大多數(shù)Silverlight DataGrids單元格不支持單元格合并。這種情況在VIBlend DataGrid for Silverlight下不會有。您可以通過改變任意網(wǎng)格單元格的行間距和列間距屬性輕松地合并網(wǎng)格單元格。
數(shù)據(jù)綁定和非綁定模式
VIBlend Data Grid for Silverlight允許您工作在綁定和非綁定模式。您可以綁定到不同的數(shù)據(jù)源,如數(shù)據(jù)庫表格,泛型集合等。
在行和列上分層
分層的航和列支持是我們Data Grid產(chǎn)品的核心。它工作在綁定和非綁定模式之外。您可以使用它來分組您的數(shù)據(jù),構建自定義的布局,顯示分層的數(shù)據(jù)結構以及構建和操作透視表。
數(shù)據(jù)排序
該數(shù)據(jù)網(wǎng)格控件支持內置的強大的排序功能,如單擊自動排序,從一個上下文菜單上選擇排序選項以及通過APIs排序。該數(shù)據(jù)網(wǎng)格自動地識別出網(wǎng)格單元的類型并選擇最合適的比較。您也可以實現(xiàn)并使用一個自定義的比較器。不像市場上的其他數(shù)據(jù)網(wǎng)格,VIBlend Data Grid允許您在行和列上進行排序。該排序在綁定和非綁定模式中任何可能的配置,包括行分組和透視表,都工作的很好。
過濾
數(shù)據(jù)過濾在所有專業(yè)的數(shù)據(jù)網(wǎng)格控件中是一個基礎的功能。VIBlend DataGrid允許您使用APIs或便捷的內置的UI過濾選項過濾數(shù)據(jù)。其內置的過濾界面支持復選框過濾以及自定義過濾規(guī)則。
行分組
分組支持顯示顯示一個平面列表為可交互的展開/折疊分組。它以具有內置拖放,排序和過濾功能的多列運行。
透視表
VIBlend DataGrid是市場上唯一的結合了傳統(tǒng)的數(shù)據(jù)視圖,分層網(wǎng)格和透視圖功能于一個單一的組件的產(chǎn)品。您不需要擔心有關購買、學習和集成兩種和三種不同組件的任何問題。
通過標簽的數(shù)據(jù)透視表排序
通過他們的標簽文本該列和行的分層結構可以排序。這些排序選項除了標準單元格的單元格值的升序和降序功能外還有其他可用的功能。
簡潔的樣式和傳統(tǒng)的透視行渲染
該數(shù)據(jù)網(wǎng)格控件支持兩種不同的行分層布局樣式。該簡潔的樣式使用了我更少的空間,并且父級行在它的子行之上渲染,不管它們展開狀態(tài)。
數(shù)據(jù)聚集能力
支持透視單元格聚集功能,如最小,最大,求和,求平均,產(chǎn)品,計數(shù),StDev, StDevP, Var, VarP。
自動總計和小計
用于透視行和列的可選的顯示和自動地總計和小計計算
嵌套的數(shù)據(jù)網(wǎng)格
靈活的布局使得任何內容或UI組件,包括嵌套的數(shù)據(jù)網(wǎng)格的嵌套變得非常容易。
行詳細信息
可擴展的行詳細信息是內置的并且易于使用。您可以更改行詳細信息地區(qū)的高度并使用自定義的數(shù)據(jù)模板。
滾動性能
選擇不同的滾動模式,包括遞延滾動,試試滾動和可選的滾動動畫。
本地化支持
自定義任何語言的上下文菜單、透視設計表單以及過濾對話框的文本。
Features &Benefits:
Standard features
Among the hundreds of features VIBlend DataGrid supports rows and columns resizing, customizable tooltips, cell styles, cell templates and formatting, full drag-and-drop support for columns and rows, keyboard navigation, multiple cells selection, full row/column select mode.
In-place cell editing
Choose from many embeddable cell editors inlcuding textbox, checkbox, datetime picker, masked textbox, or any custom control of your choice.
Cells Merge
Most Silverlight DataGrids don't support cells merging. That's not the case with VIBlend DataGrid for Silverlight. You can easily marge grid cells by changing the rows span and columns span properties of any grid cell.
Data Binding and Unbound mode
VIBlend Data Grid for Silverlight allows you to work in bound and unbound mode. You can bind to different data sources like data base tables, generic collections and more.
Hierarchies on Rows and on Columns
Hierarchical rows and columns support is at the core of our Data Grid products. It works out of the box in bound and unbound mode. You can use it to group your data, build custom layouts, display hierarchical data structures, and build and manipulate pivot tables.
Data Sorting
The data grid control supports built-in powerful sorting capabilities like one-click automatic sorting, selection of sort option from a context menu, and sorting through APIs. The datagrid automatically recognizes the type of the grid cells and chooses the most appropriate comparison. You can also implement and use a custom comparer. Unlike other data grids on market, VIBlend Data Grid allows you to sort both on rows and on columns. The sorting works well in bound and unbound mode with all possible configurations including rows grouping and pivot tables.
Filtering
Data filtering is a fundamental feature in all professional data grid controls. VIBlend DataGrid allows you to filter the data using APIs or convinient built-in UI filtering options. The build-in filtering interface supports check-box filtering as well as custom filter rules.
Rows Grouping
The group-by support displays a flat list of rows as interactive expand/collapse groups. It works with multiple columns with built-in drag and drop, sorting and filtering.
Pivot tables
VIBlend DataGrid is the only product on the market that combines traditional data grid, hierarchical grid and pivot tables features in a single component. You won't have to worry about buying, learing and integrating two or three different components.
Pivot table sorting by Label
The columns and rows hierarchies are sortable by their label text. This sorting option is available in addition to the standard ascending and descending cell value sorting.
Compact style and traditional Pivot Rows Rendering
The data grid control support two different layout styles of rows hierarchy. The compact style uses less space and the parent rows are rendered above their child rows regardless of their expand state.
Data aggregation capabilities
Support for pivot cell aggregations functions like Minimum, Maximum, Sum, Average, Product, Count, StDev, StDevP, Var, VarP.
Automatic Grand Totals and SubTotals
Optional display and automatic calculation of grand totals and sub totals for pivot rows and columns.
Nested Data Grids
The flexibly layout enables easy nesting of any content or UI component including nested data grids.
Row Details
Expandable row details are built-in and easy to use. You can change the height of the row details area and use custom data templates.
Scrolling Performance
Choose different scroll modes including deferred scrolling, real-time scrolling and optional scroll animations.
Localization support
Customize the text in the context menus, pivot design forms and filtering dialogs in any language.