The DataGrid Classifies the ADO Data Type of a Column into the following base Data Types:

For example, the ADO types adChar, adVarChar, adWChar and adVarWChar, all will be treated as Text Data Type. The DGE automatically determines the base Data Type of the Column from its ADO Data Type, and Validates input as follows.

Date Data Type

It checks if the entered value is a valid date. If not, displays a message and stops the DataGrid from trying to Update the Column. Additionally, it will present the user with the DatePicker to choose a date from.
 

Text Data Type

Checks if the length of the Field is within the defined size and if not, presents a Friendly error message. The Developer may also Force a Field to Upper Case or Lower Case characters only.

Integer Data Type

In Case of an Integer Data Type, the DGE does not allow any thing except numbers, not even decimal point. The decimal point is allowed in the case of a Decimal Data Type.

Decimal Data Type

Handles much like the Integer Data Type except that decimal point is allowed for these fields.

Boolean Value

By Default, a Combo Box with Yes/No values is displayed for a Boolean column. This is customizable, and can be changed to anything like True/False, Active/Inactive etc. The user may also double click the Boolean Column to toggle it's value.

Extended Validation Explained
Download DGE and Sample Application
Pricing and Purchase

 New...
 

FormScroller

Make a Form or Part of it Scrollable. Fully automatic scrolling. More... Download...

TrueColor

Most advanced color picker you could use in your Applications, with full 24-bit 6 million color support. Let your user select any color that their screen can possibly display! More... Download...

Let us save your time

Copyright 2002 Alpha Net Consults, LLC