SandGrid

What's New in SandGrid for Windows Forms V2.2.3

• FIX: IMEs can now be used in SandGrid editors, making it friendly to Japanese, Chinese and other such character sets.
• FIX: A bug introduced in the previous build could result in the enter key failing to commit edits when in cell selection mode.

What's New in SandGrid for Windows Forms V2.2.2

• NEW: Tooltips are now rendered with system themes.
• FIX: The active editor no longer attempts to commit changes when a message box is shown in the DataError event.
• FIX: Invalid images encountered in a GridImageColumn will no longer cause an exception to be thrown.
• FIX: An exception could be thrown when re-adding rows to a datasource after previously clearing it, when virtual mode was enabled.
• FIX: Pressing enter to commit an edit when the grid was dispayed in a dialog would also dismiss the dialog.
• FIX: A row checkbox would be hidden by a cell if the cell's BackColor property was set.
• FIX: A textbox editor with Multiline and AcceptsReturn set to true would still not have the return key delivered.

What's New in SandGrid for Windows Forms V2.2.1

• FIX: CommitOnLoseFocus has been updated to support more complex editor controls, including ones with subcontrols.
• FIX: Unfiltering a large number of rows could take a long time.
• FIX: Trying to group when the datasource to which the grid is bound does not support sorting properly results in an exception rather than incorrect layout.
• FIX: Setting a sorted datasource before adding any columns to the grid could result in an exception.
• FIX: Grouping was not included in grid state serialization.
• FIX: Altering the properties of a column at design time could result in the SortColumn and GroupColumn properties of the grid being reset.
• FIX: Tooltips are now shown when a column is partially clipped by the sides of the grid.

What's New in SandGrid for Windows Forms V2.2

• NEW: SortBox control allows the user to visually define a complex grouping and sorting system for the grid.
• NEW: GridCheckBoxColumn presents bool or nullable bool types as an interactive checkbox, supporting indeterminate state.
• NEW: Right-to-left layout of columns is now supported.
• NEW: EnableSortWithinGroup property added to GridDateTimeColumn; sorting within groups is now possible.
• NEW: ColumnsReordered event added.
• NEW: Copying to the clipboard copies in CSV format (was tabbed format). Only in .NET 2.0+ version.
• NEW: Images are now allowed in a center-justified column header providing there is no text specified.
• FIX: An exception could be thrown when removing a row from a nested grid that was itself not parented to a grid.
• FIX: The grid would attempt to draw tree buttons and lines even with an invisible primary column.
• FIX: When dynamically changing the datasource of a grid, sorting information is updated based on the new datasource.
• FIX: Inserting a row at a specific point in a hierarchy after specific previous additions could result in the row not immediately showing.
• FIX: A tooltip could be shown over a GridImageColumn.

What's New in SandGrid for Windows Forms V2.1

• NEW: EmptyTextForeColor and EmptyTextHorizontalAlignment properties added, for more control over the text drawn when the grid is empty
• NEW: GridConditionalImageColumn now has TrueGroupText and FalseGroupText properties for specifying the text used when the column is grouped
• NEW: GridFileSizeColumn makes it easy to display and group file sizes in a friendly way
• NEW: HorizontalInsertionMarker and VerticalInsertionMarker properties exposed
• FIX: The background color of a button or hyperlink cell was not drawn
• FIX: The re-entrancy check in the AfterEdit event has been relaxed, allowing operations such as removing the row being edited during the event
• FIX: When using a grid with an offset primary column, the rightmost portion of a nested grid could be unclickable
• FIX: When double-clicking a column border to autosize it, the ColumnResized event was not raised
• FIX: When double-clicking a column border to autosize it, the MinimumSize property was not respected
• FIX: An exception could be thrown when removing a row from a nested grid that was itself not parented to a grid
• FIX: When rapidly clicking between rows to change the selection, multiple SelectionChanged events could be raised for the same row

What’s New in SandGrid for Windows Forms V2.0.1

• NEW: The EditorType of a column can now be set at design-time
• FIX: When using rubber-band selection in a small grid with StretchPrimaryGrid set to false, the coordinates of the rectangle could be incorrectly restricted
• FIX: A tooltip was shown on GridConditionalImageColumn
• FIX: When dynamically filtering rows with the SetFilteredOut method, a measure and layout cycle was not always triggered
• FIX: Assigning to the EditorType property of GridChooseEditorEventArgs could fail

What’s New in SandGrid for Windows Forms V2.0

• NEW: GridButtonColumn and GridHyperlinkColumn added
• NEW: AutoSort property on columns replaced with AutoSortType; interactive multi-column sort is now possible
• NEW: SandTreeView control added, a simpler control designed to mimic a TreeView without the SandGrid features irrelevant to such a task
• NEW: Rubber-band selection of items is now possible and automatically works when multiple selection is enabled
• NEW: Selection of group heading objects with the mouse is now possible
• NEW: ShowRootLines property added to InnerGrid and SandGrid classes
• NEW: SetFilteredOut method added to GridRow: rows can now be selectively filtered out from view
• NEW: GridFriendlyGroupNameColumn added for easy creation of arbitrary groups at design time
• NEW: ShrinkToFit property added to SandGridPrintDocument
• NEW: The Office 2007 renderer now allows you to choose between Excel-like and Outlook-like column headers
• NEW: The Office 2007 renderer now allows you to choose between divider and button group header styles, to facilitate emulating the collapsible Outlook TreeView
• NEW: ChooseEditor event added to SandGrid: you can now dynamically select which editor is used for a cell
• NEW: HScrollOffset and VScrollOffset properties exposed in the grid
• NEW: CellVerticalAlignment property added to columns
• NEW: Generic GridColumn and GridCell types added
• NEW: Cells have a BackColor property
• NEW: StandardTab property allows the Tab key to work in a standard way even in a grid with cells, if necessary
• NEW: ColumnResized event added to SandGrid
• NEW: HideSelection property introduced
• IMPROVED: Exporting facilities improved to better handle strings and newlines
• FIX: The PrimaryColumn property could be reset in the designer
• FIX: Ctrl-A could be used to select all elements within the grid even when multiple selection was disabled
• FIX: Cell images are now accounted for in automatic measurement of rows
• CHANGE: Group property replaced with GroupColumn and GroupDirection properties, separating grouping from sorting
• CHANGE: Ctrl-A, Ctrl-C and Ctrl-V are caught differently, meaning if you have menu items that attempt to catch these, the menu items will now succeed in doing so. Divelements have exposed the ClipboardOperations class so your application can call the default functionality

What's new in SandGrid for Windows Forms V1.2:

• NEW: Build machine activation is supported
• NEW: Office 2007 renderer now included with the product
• NEW: AllowPaste property added; grid now supports automatic pasting from the clipboard in either plain text or CSV format
• NEW: FlatRows property added to SandGrid class
• NEW: The grid itself draws a themed border when themes are enabled in the operating system

Overview

Data in a SandGrid control can come from many sources - it operates in both bound and unbound states without compromising on features in either mode of operation. It complies with the standard Windows Forms databinding model and understands data sources from the simple IList to the advanced IBindingListView. It also offers a middle ground between bound and unbound operation with virtual rows, which give you the speed of only having your data in one location without sacrificing the flexibility of presentation.

Sorting and grouping are fundamental to data display and SandGrid fully supports both with an extensible, lightning-fast API. The grid will automatically enable sorting and grouping by any column when populated. When bound to data it will use the data's native sorting methods, and when unbound its own native sorting is used. You can even establish different sorting on different levels of data, when operating as a tree of nodes. Standard single-column as well as advanced multi-column sorting is supported. Grouping is automatically applied to the first level of sort, if enabled.

SandGrid ships with a number of specialized column and cell types for quickly integrating with different types of data. A DateTime column knows how to group date information in a user-friendly manner, and various image columns know how to translate a row of data into an image selection to display. A ProgressBar column can display progress for individual cells. It is easy to add your own columns and cells with their own distinct behavior and look and feel. Columns can be autosized based on their contents, based on the available screen space or set to fixed widths. Of course, the user can change column widths and SandGrid supports a mechanism to quickly serialize the state of any grid - including column widths, visibility, display order and sort state.

The SandGrid architecture is such that every element in the grid receives its own mouse commands and is responsible for its own painting. This design offers tremendous extensibility possibilities, and several features of the library itself take full advantage. A special kind of row allows you to nest another full-featured grid within itself, and of course this can be used recursively to represent trees of data with different schemas. This is best illustrated by binding to a hierarchical data source such as a DataSet with relations. Related views are automatically made available and can be expanded and explored.

Features

General

• Easily replaces the ListView, TreeView and DataGridView controls
• Fast sorting (both single and multi-column supported)
• Outlook style grouping on the first level of sort
• Full-featured independent nested grids
• Use bound or unbound without sacrificing capabilities
• Printable including Print Preview
• Virtual rows bridge the gap between ease of binding and flexibility of static data
• Supports both row and cell level selection, with configurable highlights
• Optimized text display engine ensures very fast drawing
• Pluggable renderer support for customised drawing of common elements
• Editing support through an extensible editor framework
• Export to HTML function
• Grid lines in horizontal, vertical, or both directions
• Automatic clipboard handling
• Highly customizable and extensible

Columns

• Autosized columns based on either screen space or column contents
• User resizing and autosizing
• Hidden columns
• Reordering through drag and drop
• Specialized column types decrease development time
• Automatic sorting
• Easy serialization of column state (width, visibility, display order, sorting)

Rows

• Every row has a collection of child rows for true hierarchical data
• Shading of alternate rows
• User resizing
• Reordering through drag and drop

For more features, please go to the Evals&Downloads section.

Each license includes 1 year of minor upgrades and email technical support.