What's New in Janus GridEX for .NET

What's New in Janus GridEX Control for .NET v4.0.36?

  • Support for Windows 8
  • Supports for Visual Studio 2012

What's New in Janus GridEX Control for .NET v4?

  • Office 2010 Visual Style
  • Support for Visual Studio 2010 and .Net Framework client profiles:  Janus controls can now be used in projects targeting .Net Framework client profiles.
  • Support for multiple cell selection: MultipleCellSelection option is now available for SelectionMode property. When this option is selected, user can select multiple cells in the control like in a excel spreadsheet. To retrieve in code which cells are added you can use GridEX.SelectedCells property that returns a collection of selected cells in the control.
  • ButtonEnabled property in GridEXCell allows you to enable/disable buttons in individual cells.
  • ButtonStyle property in GridEXCell allows you to have different buttons styles in cells from the same column.
  • CellDisplayType property in GridEXCell allows you to have different display types for cells in the same column. With this property, you now can have text, image or checkboxes cells under the same column.
  • EditType property in GridEXCell allows you to have different edit types for cells in the same column. With this property you now can have cells that can be edited as text, combo or as a checkbox under the same column.
  • Enabled property in GridEXCell allows you to enable/disable individual cells in the control.
  • ValueList property in GridEXCell allows you to define a valuelist for value replacement and or as the source for the dropdown in a combo editor on each cell.
  • TreeCollapseGlyph and TreeExpandGlyph properties allows you to customize the expand/collapse images in the control.

What's New in Janus Grid Control for .NET V3.x?

  • Janus GridEX for .NET is 64-bit compatible.
  • MultipleValues Columns: A column can be bound to a list of values.  MultipleValues columns are especially useful when dealing with many-to-many relations. For example, if there is a many-to-many relation between tables “Products” and “Categories” you can bind a grid to the table “Products” and add a MultipleValues column bound to the relation showing (in a single cell) all the categories a product belongs. To edit these cells, you can use a checked combo box where the user can check/uncheck the list of available categories.The GridEX Control is also capable to group columns with more than one value. When grouping by a MultipleValues Column a record in the table could belong to more than one groups and the control will present a copy for those repeated records in each of the corresponding groups. When an edition in those copied record is made, the control will automatically reflect the changes in each copy
  • SelfReferencing Tables: A table with a self-referencing relation can be displayed as a tree. For example, you can bind a GridEX control to a “Messages” table. If a message can contain other message as a child, you can use HierarchicalMode.SelfReferencing in the GridEXTable and show the control as tree with multiple columns
  • Custom Grouping: A new GridEXCustomGroup class is provided to let you specify custom group definition. There are two types of custom groups:
    • Composite Columns: Rows in the GridEX control are grouped based on the values of two or more columns in the same group row. For example: You can specify columns: “Country” and “City” and the control will create a group row for each different combination of the values of these columns
    • Conditional Group Rows: You can specify each of the group rows a Group contains and specify the condition that rows must meet in order to be part of the group row
  • Hierarchical Grouping: Rows in a table can be grouped based on the values of a column that belongs to a child table. For example, in a hierarchical grid showing Customers-Orders-Order_Details, you can group Customers table by the “Product” column in Order_Details table. Showing you a grouped view of customers based on the products ordered
  • Hierarchical Filters: Rows in a table can be filtered based on the values of a column that belong to a child table
  • Improved Performance on Hierarchical Mode: Janus data manipulation classes were completely redesigned to decrease the time used to load child lists to a fraction of the time needed in previous versions
  • Nested Properties Binding: A column can now be bound to a property of a sub-object in the original DataRow. For example, if a control is bound to a list of “Contact” objects and the Contact class has a property that returns a “ContactName” object where “ContactName” is a class with two properties: “FirstName” and “LastName”, you can bind a column to Contact.ContactName.FirstName setting its DataMember property equal to “ContactName.FirstName”
  • Unbound Mode: New Unbound mode in GridEX control allows you to populate rows using AddItem method.
  • Unbound Columns:You can add an unbound column to a bound grid. There are two types of unbound columns:
    • UnboundFetch: The value of the cells in these columns is set in the LoadingRow event. This mode is useful when you want to have a calculated cell where the value is based on the values of other cells in the same row
    • UnboundKeep: The value of the cell can be set by the user and the control will keep that value
  • KeepRowSettings Property: When this property is set to true, the control retains the row and cell properties even when the rows are scrolled out of view. By default, GridEX control fires the FormattingRow event to let you specify cell properties of rows that are displayed in the grid.These settings are cleared once a row is no longer visible and they must be set again when the FormattingRow event is fired for the row. In cases where you need to set cell properties (like its FormatStyle outside) the FormattingRow, you can use this property to true and the control will keep the property you set even when the row is scrolled out of view
  • UseGroupRowSelector Property: This property allows you to display a checkbox in group rows that checks/unchecks all the rows inside a group with one click
  • TotalRowPosition property: When using a TotalRow in the grid, you can now specify whether you want to show the total row as a scrollable row at the end of the list or fixed at the bottom of the display area in the control
  • GridEXGroupHeaderTotal.ColumnAlign Property: This property allows you specify a column to which align a defined group header total
  • CardView Appearance: CardViewGridLines and CardInnerSpacing properties were added to let you change the appearance of a card in GridEX control. Now, it is possible to show a card with grid lines between its fields and the space specified in CardInnerSpacing between those fields
  • Export to Excel: A new GridEXExporter component is provided to let you export the data displayed in a GridEX control as an Excel XML document
  • FieldChooser Control: In addition to the ShowFieldChooser method, you can use the new GridEXFieldChooserControl to use the control inside a panel of your form instead of showing it as a floating window outside your application
  • CheckedComboBox Control: This new control acts as combo box that can be bound to a list of values where the user can check/uncheck multiple items in the dropdown to add/remove items from the list specified as value of the control