ComponentOne VSFlexGrid Pro

VSFlexGrid Pro 8.0 makes customizing the display and presentation of dynamic data for Windows, Internet, or Intranet applications is now easier than ever! A powerful upgrade to the MSFlexGrid that comes in the box with Visual Basic, VSFlexGrid Pro gives you a full range of features for building flexible, robust front-ends for database applications. Customize the display and presentation of dynamic data in your projects with a host of new ways to display, edit, format, organize, summarize, and print tabular data!

Customize VSFlexGrid Pro's appearance and behavior to place the outline tree in specific columns, then add data-entry capabilities using plain or masked editing, multi-column list or combo boxes, or checkboxes. Then make the display dynamic by allowing users to group, sort, and total data in different ways simply by dragging columns around.

Latest News about ComponentOne VSFlexGrid Pro

This product is no longer available individually - it must be purchased as part of a suite - posted 5/21/2007

Starting 5/21/07, renewal skus for individual products and individual studios are no longer offered except under special circumstances. This is the final phase of ComponentOne's year-long transition from single components to exclusively offering the ComponentOne Studio Enterprise suite of developer tools. For more information, ComponentOne Studio Enterprise


Image Gallery - Click Image to Enlarge

Call or mail for pricing and product availability.

---

Detailed Product Description

The Flex Means Muscle, the Pro Means Professional

When working with Microsoft's FlexGrid, did you ever wish that you could do more? Like more powerful masked editing? Then you need professional-strength help - VSFlexGrid Pro from ComponentOne. VSFlexGrid Pro takes the same code-base used for MSFlexGrid and MSHFlexGrid in VB 6.0 and sends it to a new level.

Flexing New Features

VSFlexGrid Pro is a powerful, lightweight, data-aware grid control that gives a comprehensive feature set for display and presentation of dynamic data within Windows or web applications. It features native support for ADO 2.0 and OLE DB as DAO, so you can migrate your applications to the newest generation of data access methods or continue using existing methods. The list of new features in VSFlexGrid Pro is longer than your arm!

May I Translate Your Combo?

The new ColComboList property has two advantages over the traditional ComboList property. One is that you set it once for each column and don't have to set it again in response to the BeforeEdit Event. The other is that you can use the ColComboList as a Data Dictionary. And the syntax of the ComboList property has been extended to allow for display of multicolumn lists in the drop-down part of the list.

Your Buttons Are Popping!

The new VSFlexGrid Pro control displays drop-down buttons automatically for cells with associated combo boxes or drop-down lists. You can edit the cells directly by clicking the button with the mouse. In addition, you can display pop-up buttons in cells.

The List Goes On and On and...

Other features include variant RowData and ColData. There's also FindRow, which allows you to look up specific rows based on RowData values. Improved outlining allows the outline tree to be displayed in any column, including those that hold data. You can import or export Comma or Tab-delimited files and bind VSFlexGrids to Visual Basic Arrays or to other VSFlexGrids. ExplorerBar properties allow you to use column headings to sort and pivot columns without any code. And with RowHidden and ColHidden properties, you can hide rows or columns.

I have to stop somewhere, but believe me, the list doesn't. I haven't told you about the AutoSearch, the improved formatting, the Automatic Check boxes, the automatic auditing, the improved merging, the faster painting, the new events for better UI control, or even scroll tips. You can find out about those by buying VSFlexGrid Pro today!

• Native support for ADO 2.0, OLE DB, and DAO
• Outlook-style sorting and pivoting by column headings
• Advanced outlining capabilities
• No external dependencies, no DLL versioning problems

---

Features:

Light Version
VSFlexGrid Pro includes three versions of the control, each supporting a different type of data-binding. Use the ADO/OLEDB version for compatibility with the latest database standards, or the DAO version for compatibility with existing systems and projects. And if your application doesn't need database support, the new Light version reduces footprint size and eliminates the need to distribute ADO DLLs. A version that supports Unicode is also included. Also, the VSFlexString control has been repackaged in a separate file to reduce the footprint of projects that use only one of the controls.

Integrated Printing
You can print the grid with a single statement. You have complete control over paper orientation, margins, and footer text, or show a dialog box to let the user select and set up the printer. Printing events allow you to control page breaks, add repeating header rows, or add custom elements to each page.

"Frozen" Rows and Columns
Rows and columns on the grid can be frozen so they remain visible as the user scrolls the control, yet can be selected and edited. The appearance of the frozen cells is customizable, and users can expand and shrink the frozen area with the mouse!

Wallpaper
Use any picture as a backdrop for your grids, or add logos or textures to enhance the appearance of your applications.

Custom Data Sources
You can bind the grid to your own data source objects, which you can create with Visual Basic or Visual C++. Bind grids to existing data structures, use calculated "virtual" fields, perform data validation, or load data on-demand!

Translated ImageLists
Grid columns can now be bound to image lists, which is an easy and efficient way to display database information graphically.

Refer to Columns by Key
You can refer to columns by name instead of position. Column keys are automatically assigned to field names when the grid is data-bound, or you may assign them with code. You can later refer to a column using a ColIndex(ColKey) syntax, which will retrieve the column you want even if the user has moved it to a different position on the grid.

Range Aggregates
With a single statement, you can calculate totals, averages, and other statistics for ranges of cells!

Easy ComboLists
The BuildComboList method allows you to build strings for use with the ColComboList property.

Simple and Efficient User Interface
VSFlexGrid Pro includes a simple user interface to make the VSFlexGrid control simple to use. You can:

• Make combos and lists boxes "smart," giving them select-as-you-type capability.
• Make columns resize to fit when the user double-clicks on the column resize area.
• Show images on cell buttons.
• Customize the reset time for AutoSearch operations.
• Customize the look of outline trees.
• Show sort icons on column headers, and provide better feedback while moving columns.
• Allow users to start editing by double-clicking a cell.
• Allow buffered painting for an even smoother appearance.
• Make fixed cells highlight the current selection (Excel-style).
• Resize all rows simultaneously (you can also resize groups of columns and rows).
• Control the appearance of the default field.
• Plus, the OLEDragDrop Data object has been enhanced.

More Control through New Events
Now you can take total control over the behavior of the VSFlexGrid control so you can:

• Perform data formatting/conversions as data is being read from written to bound record sets.
• Provide conditional formatting (based on cell contents) and display dynamic data summaries.
• Control outline trees and even build them asynchronously.
• Create protected ranges that cannot be selected.
• Control scrolling.

Other new Properties and Methods
Additional enhanced properties and methods let you:

• Determine whether the grid is in edit mode and give you access to the editor window handle.
• Load data from Variant arrays or other VSFlexGrid controls without binding.
• Get a row's parent, first, or last child nodes in a tree outline.
• Bring arbitrary cells into view.
• Return the selection in order for use as loop limits.

Better Design-Time Interface
The VSFlexGrid Pro roperty pages make it even easier to set properties. You can specify fixed-cell contents, column widths and alignments, data types, edit masks, and combo lists visually at design time. Or use the Visual Basic property browser to see a categorized view of the VSFlexGrid properties.

Comprehensive Documentation
VSFlexGrid Pro includes a complete and comprehensive help files, with more sample code and details on the use of each property, event, and method. We've also developed several new samples in Visual Basic and in Visual C++ to illustrate the main aspects of the control. The samples include a generic, categorized property page object written in Visual C++ that you can use as-is or customize to fit your needs.

Support for Hierarchical Data
VSFlexGrid Pro may be used as an outliner for displaying data hierarchically: it behaves like a Tree control, displaying nodes that can be collapsed or expanded to show branches containing additional data. Outline trees can be displayed in any column, and can even be built asynchronously. The look of outline trees can also be customized.

Merged Cells
Merge contiguous like-valued cells, making them span multiple rows or columns. Cell merging can be used to create merged table headers, merged data views, or grids where the text spills into adjacent columns.

Masked Editing
Input templates can be specified to automatically control and validate text input, minimizing data entry errors. The mask syntax is similar to the one used by the Microsoft MaskedEdit control and by Microsoft Access.