VSFlexGrid Introduction

The VSFlexGrid control is a powerful, full-featured grid. It provides new ways to display, edit, format, organize, summarize, and print tabular data.

The VSFlexGrid control was designed to be used either in unbound mode, where the grid "owns" the data, or in data-bound mode, where the grid is used to view and edit data that that belongs to a database.

VSFlexGrid 8.0 ships with three versions of the VSFlexGrid control. Each version has its own OCX file and supports a different type of data binding:

OCX File	Description
VSFLEX8.OCX	This version provides support for ADO/OLEDB data Binding, the latest data binding standard from Microsoft. It requires ADO to be installed on the Computer.
VSFLEX8D.OCX	This version provides support for DAO data binding, the more traditional type of data binding supported by Visual Basic's built-in Data Control.
VSFLEX8L.OCX	This version has no support for data-binding. Use it when your application does not require data-binding and you want to reduce the number of components your application depends on.
VSFLEX8U.OCX	This is a Unicode version that provides support for ADO/OLEDB data binding. It only runs on Windows NT systems.
VSFLEX8N.OCX	This file contains a Unicode version of the VSFlexGrid Light control.

The following sections walk you through the main features in the VSFlexGrid control:

Basic Operations

Describes how to set up the grid dimensions and layout, and the concepts of "current cell" and "selection".

Editing Cells

Describes how to implement simple text editing, drop-down lists and combo lists, cell buttons, editing masks, and data validation.

Formatting Cells

Describes how to customize the appearance of the grid by formatting numbers, dates, and boolean values, or by changing fonts, colors, alignment, and pictures for individual cells or ranges.

Merging Cells

Describes how to change the grid display so that cells with similar contents are merged, creating "grouped" views that highlight relationships in the data.

Outlining and Summarizing

Describes how to add subtotals to grids and how to build outline trees.

Data Binding (ADO and DAO)

Discusses the basic aspects of ADO/OLEDB and DAO data-binding.

Other types of Data Binding

Discusses how you can bind the VSFlexGrid control to arrays of Variants, to other VSFlexGrid controls, or to custom data sources that you can implement yourself.

Saving, Loading, and Printing

Describes how you can save the contents or formatting of a grid and re-load it later, or exchange grid data with other applications such as Microsoft Access and Excel. This section also shows how you can print grids.

Using VSFlexGrid in Visual C++

Shows useful techniques and programming tips on how to use the VSFlexGrid control in Visual C++, both in MFC and in ATL projects.

Using VSFlexGrid in Visual J++

Shows programming tips on how to use the VSFlexGrid control in Visual J++.

VSFlexGrid Property Groups

Presents a map of the main VSFlexGrid properties cross-referenced by function.