SandGrid - Summary

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Summary

SandGrid by Divelements

URLs: sandgrid, divelements

Add a professional, versatile list control to your application. SandGrid is a list control capable of displaying data in tabular and hierarchical form. It was designed from the ground up to support trees of items and to be truly extensible. Because of its special architecture it offers a replacement for the ListView, TreeView and DataGridView controls - offering more customization options and a consistent development experience.

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.

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

NEW: Sprung column resizing improved; original setting of Width property is now maintained leading to greater precision.

NEW: MinimumWidth property is now respected for sprung columns.

FIX: It was possible with a combination of no live resize, scrolling and hidden columns to drag a column edge such that an exception would be thrown.

FIX: EmptyText was not displayed if rows were present but filtered out.

FIX: Invoking the UpDownEditor by starting to type would fail to relay the first typed character into the editor.

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

Add a professional, versatile list control to your application.

Pricing: SandGrid 2.2.4 - includes 1 year free product updates and unlimited email support 1 Developer License, SandGrid 2.2.4 - includes 1 year free product updates and unlimited email support 2-3 Developer License (Price per Developer, Minimum quantity 2), SandGrid 2.2.4 - includes 1 year free product updates and unlimited email support 4-7 Developer License (Price per Developer, Minimum quantity 4), SandGrid 2.2.4 - includes 1 year free product updates and unlimited email support 8 Developer License or above (Price per Developer, Minimum quantity 8), SandGrid 2.2.4 - includes 1 year free product updates and unlimited email support Unlimited Site License (Allows Unlimited Developers at a Single Physical Address), SandGrid - Support Renewal 1 Developer Support Renewal License, SandGrid - Support Renewal 2-3 Developer Support Renewal License (Price per Developer, Minimum quantity 2), SandGrid - Support Renewal 4-7 Developer Support Renewal License (Price per Developer, Minimum quantity 4), SandGrid - Support Renewal 8 Developer or above Support Renewal License (Price per Developer, Minimum quantity 8), SandGrid - Support Renewal Unlimited Site Support Renewal License (Allows Unlimited Developers at a Single Physical Address)

Evals & Downloads: See the SandGrid Screenshot Gallery, Read about SandGrid Hierarchies, Read about SandGrid Nested Grids, Read about SandGrid Columns, Read about SandGrid Rendering, Read about SandGrid Rows, Read the SandGrid Help, Read the SandGrid License Agreement, Download the SandGrid 2.2.4 for VS2005 evaluation on to your computer - Displays Evaluation message

Operating System for Deployment: Windows Vista, Windows XP, Windows Server 2003, Windows ME, Windows 2000, Windows 98

Architecture of Product: 32Bit, 64Bit

Product Type: Component

Component Type: .NET WinForms, .NET Class, 100% Managed Code

Built Using: Visual C# .NET

Compatible Containers: Microsoft Visual Studio 2008, Microsoft Visual Studio 2005, Microsoft Visual Studio .NET 2003, Microsoft Visual Studio .NET, Microsoft Visual Basic 2008, Microsoft Visual Basic 2005, Microsoft Visual Basic .NET 2003, Microsoft Visual Basic .NET, Microsoft Visual C++ 2008, Microsoft Visual C++ 2005, Microsoft Visual C++ .NET 2003, Microsoft Visual C++ .NET, Microsoft Visual C# 2008, Microsoft Visual C# 2005, Microsoft Visual C# .NET 2003, Microsoft Visual C# .NET, .NET Framework 3.5, .NET Framework 3.0, .NET Framework 2.0, .NET Framework 1.1, .NET Framework 1.0

Keywords: sand grid SandGrid

datagrid controls, datatable controls, datagrid components, datatable components, datagrid, data grid, data table, net gridview, net datagrid, data grid, grid control, net datatable, c# gridview, c# datagrid, asp.net datagrid, grid asp, vb.net datagrid

Entry data-entry

treeview, list, tree view, tree-view, list-view, listview, listbox

Spreadsheet spread sheet worksheet workbook excel lotus 123 1-2-3 xls xl

Part numbers: PC-517020-459482 517020-459482 PC-517020-459484 517020-459484 PC-517020-459486 517020-459486 PC-517020-459490 517020-459490 PC-517020-459498 517020-459498 PC-517020-459488 517020-459488 PC-517020-459492 517020-459492 PC-517020-459494 517020-459494 PC-517020-459496 517020-459496 PC-517020-459500 517020-459500