SharpGrid is a full-featured database-aware ActiveX grid control. It can be used in bound (both OLEDB and ICursor), unbound, and virtual data modes. SharpGrid has all of the features expected from a grid control: fast and easy manipulation of tabular data, powerful display capabilities, easy-to-use unbound mode, easy-to-use event and interface-based virtual modes, Outlook-style grouping, and more.
SharpGrid is based on a per-developer licensing scheme, and it is royalty free to distribute. But it doesn't stop there. SharpGrid has some unique features that will make your application stand out: group calculations, row filtering, preview pane, stage-driven custom draw model, XML layouts, HTML export, scroll tips, cell tips, frozen columns and rows, alpha blending and more It can also be used in both Windows-based and Web-based applications.
SharpGrid also includes the ActiveReports Viewer control which provides Print Preview functionality.
Windows Application Development
- Microsoft Visual Basic 5, Visual Basic 6 or Visual C++ 6
- Microsoft Windows 9x or later
Web Application Development
- Internet Explorer version 5 or 6
- Microsoft Windows 9x or later
Supported Languages
- Microsoft Visual Basic 5
- Microsoft Visual Basic 6
- Microsoft Visual C++ 6
- Internet Explorer 5
- Internet Explorer 6
Features
Data Binding
-
SharpGrid 2.0 includes two separate grid controls, one for the older ICursor data source and one for the OLEDB based data source. The ICursor grid can bind to Visual Basic's intrinsic Data Control. The OLEDB grid control can bind to the Microsoft's ADO Data Control, the Data Environment or directly to OLEDB recordset.
Grouping
-
SharpGrid can group successive rows that have the same value in the grouping columns. Grouping column is a column that is specified, with some other group settings, by the SGGroup object. Each group has a group heading row and each group can have a group footer row. Group header and footer rows display values defined by the SGGroup properties. Among other things, group headers and footers can show results from various calculations and formulas. Groups can be created from code and/or you can allow users to drop column headers into the groupby box.
Filtering
-
SharpGrid allows you to filter grid rows. When a row is marked with a filter marker, the grid can display it in some special manner. For example, rows can be hidden or rendered with "FilteredRow" style. In addition, you can enumerate rows and perform some custom action on filtered rows.
Styles
-
SharpGrid uses a style model to simplify customization of the grid's appearance. SharpGrid styles are organized in a Style hierarchy with the "Normal" style in the hierarchy root. Each SGStyle object encapsulates appearance attributes such as font, picture, color, alpha blending or formatting. Style hierarchy enables attribute inheritance, so, for example, if color is not initialized in one style, it is inherited from a parent style.
Print and Print Preview
-
SharpGrid taps into the powerful rendering engine of Data Dynamics ActiveReports to provide print and print preview capabilities. SharpGrid's output pages can be merged and printed with output from ActiveReports pages. In addition, you can export the pages using ActiveReports' Rich Text, PDF, and TIFF export filters.