GetDataFillData Method

Applies To

fpSpread control

Description

Returns data from the database inside the DataFill event.

Syntax

C++

BOOL CSpreadSheet::GetDataFillData(VARIANT* Var,short VarType)

Visual Basic

fpSpread.GetDataFillData(Var As Variant, ByVal VarType As Integer) As Boolean

Parameters

The following parameters are available:

Parameter	Description
Var	Data retrieved from the database
VarType	Data type expected (Refer to the Visual Basic documentation for Variant data types.)

Remarks

This method lets an application interact with the data before the data enters the sheet.

Note: The VarType parameter represents a variant data type. The DataType parameter for the DataFill event represents the data access type. These parameter values are not equivalent. For example, the DataFill event would return a value of 4 in the DataType parameter for a long integer. For the GetDataFillData method, the variant data type for a long integer is represented by a value of 3.

This method is called for the current sheet setting unless you first set the Sheet property to specify the sheet with which you want to work.

Return Type

True if successful; otherwise, False.