SD DataGrid

Latest File Version: 3.3.0.0
Updated: July 2007

Announcement: As of version 3.3 SD DataGrid is available free of charge. This is the full version, the only difference is that technical support from the author will no longer be available.

SD DataGrid is a powerful grid control DLL for displaying and editing data from a variety of sources. No registry entries are needed to install SD DataGrid. Simply install it in the system folder or the same folder as your program and it's ready to use. It is not an OCX or ActiveX control so additional support files are not required. SD DataGrid relies entirely on the Win32 API and standard common controls. Over 80 functions are provided for managing data entry and customizing the grid appearance.

Features

Language independent: C++, C, BASIC. Any Win32 programming language that can use dynamic link libraries can use SD DataGrid.

SD DataGrid supports ODBC compliant databases as well as random access and delimited file data sources.

The SD DataGrid library includes a full set of ODBC functions that provide a built in means of working with databases, tables, individual records, and entire SQL result sets.

Connect to any ODBC compliant database.
Allocate and free environment and statement handles.
Create and drop tables
Add and remove fields
Set table field properties and keys.
Execute any type of ANSI SQL statement on the database.
Use transaction processing with databases that support it.
Collect detailed information about table fields.
Create *.mdb databases.
Compact *.mdb databases.
Repair *.mdb databases.

- There is no dependence on separate support files. SD DataGrid relies entirely on the Win32 API.
- Short learning curve.
- Easy to implement.
- Multiple grid support.
- Data entry provided through single or multi line Edit controls, Combo Boxes, and Check Boxes.
- Blank record support for data entry into a new file or table.
- Records can be loaded by SQL statement, one field at a time, one record at a time, or with entire random or delimited files.
- Almost unlimited number of records. The limit is 2,147,483,647 records or the size of the system's memory.
- Records can be exported to different formats.
- Individual fields can be programmatically written and read.
- Columns can be dimensioned from 1 to 500
- Each field can hold up to 32,000 characters.
- On-entry property of fields can be either No-Selection or Select-All.
- User sizable rows and columns.
- New rows are automatically added to the grid.
- Read-only attribute can be applied to individual columns or the entire grid.
- Internally maintained data buffer with minimal memory usage. Each field uses only enough memory to contain the field's data.
- The grid appearance is fully customizable.
    Fonts
    Column colors
    Grid line color and visibility
    Current system colors and fonts are the default settings.
    Optional Row numbers
    Row selection foreground and background colors.
    Left, right, or center aligned column labels and cell data.
- Internal Undo buffers for individual fields and records.
- Internal Undelete buffer for 10 deleted records.
- Built-in search capabilities.
- Event notifications enable you to monitor and validate all data entry.
- Navigation out of a cell or row can be canceled.
- Event notifications can be sent to a callback function in your program or to your application's window procedure.
- Data changes can be saved upon navigation to a different field or row, or all-at-once at a time of your choice.
- Internal flags are available to test for recordset data changes and to test any row for data changes.

User Features

- Full support for keyboard navigation.
- Full support for standard editing keys.
- Current record indicator.
- New record indicator.
- Undo.
- Undelete.
- Record searching.