ModHFGrid Control

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

The Microsoft® Office XP Developer Hierarchical FlexGrid (ModHFGrid) control displays and operates on tabular data. It makes possible complete flexibility to sort, merge, and format tables containing strings and pictures. When bound to a data control, ModHFGrid displays read-only data.

Syntax

ModHFGrid

Remarks

You can place text, a picture, or both in any cell of a ModHFGrid. The Row and Col properties specify the current cell in a ModHFGrid. You can specify the current cell using code, or the user can change it at run time using the mouse or the arrow keys. The Text property references the contents of the current cell.

If the text in a cell is too long to display in the cell and the WordWrap property is set to True, the text wraps to the next line within the same cell. To display the wrapped text, you might be required to increase the cell's column width (ColWidth property) or row height (RowHeight property).

Use the Col and Row properties to determine the number of columns and rows in a ModHFGrid. Use the Band properties to determine the band styles in ModHFGrid.

Displaying Hierarchical Recordsets

A major feature of the ModHFGrid control is its ability to display hierarchical recordsets — relational tables displayed in a hierarchical fashion. The easiest way to create a hierarchical recordset is to use the Data Environment designer and assign the DataSource property of the ModHFGrid control to the Data Environment. In addition, you can create a hierarchical recordset in code using a Shape command as the RecordSource for an ADO Data Control, as shown in the following example:

' Create a ConnectionString.
Dim strCn As String
strCn = "Provider=MSDataShape.1;Data Source=Nwind;" & _
"Connect Timeout=15;Data Provider=MSDASQL"

' Create a Shape command.
Dim strSh As String
strSh = "SHAPE {SELECT * FROM `Customers`} AS Customers " & _
"APPEND ({SELECT * FROM `Orders`} AS Orders RELATE " & _
"CustomerID TO CustomerID) AS Orders"

' Assign the ConnectionString to an ADO Data Control's
' ConnectionString property, and the Shape command to the 
' control's RecordSource property.
With Adodc1
   .ConnectionString = strCn
   .RecordSource = strSh
End With
' Set the HflexGrid control's DataSource property to the 
' ADO Data control.
Set HFlexGrid1.DataSource = Adodc1

Note   Before you can use a ModHFGrid in your application, you must add the MSHFlxGd.ocx file to your project. To include the file in your project automatically, put it in the Autoload file. When distributing your application, you should install the MSHFlxGd.ocx file in the user's Microsoft® Windows® System directory. For more information about adding a Microsoft® ActiveX® control to a project, see "Standard ActiveX Controls" in the Visual Basic Programmer's Guide available in the Microsoft® Developer Network (MSDN®) Library.

See Also

Properties, Methods, and Events | Calling a Stored Procedure | Issue Tracking Team Solution | ModHFGrid Error Constants | Stored Procedures