Free Delphi Database Programming Course
Free online database programming course for beginner Delphi developers. Focus on ADO techniques.

Accessing and managing MS Excel sheets with Delphi
How to retrieve, display and edit Microsoft Excel spreadsheets with ADO (dbGO) and Delphi. This step-by-step article describes how to connect to Excel, retrieve sheet data, and enable editing of data (using the DBGrid). You'll also find a list of most common errors (and how to deal with them) that might pop up in the process.

Adding components to a DBGrid
How to place just about any Delphi control (visual component) into a cell of a DGBrid. Find out how to put a CheckBox, a ComboBox (drop down list box) and even an Image inside the DBGrid.

A TreeView of Data
How to display a dataset of records from a table/query in a treeview component.

CheckBox inside a DBGrid
Here's how to place a check box into a DBGrid. Create visually more attractive user interfaces for editing boolean fields inside a DBGrid.

Coding Aliases
Working with the BDE aliases from Object Pascal code.

Coloring DBGrid
How to enhance the functionality of a TDBgrid component using colors.

Creating flat (non-relational) databases with no database components
A Beginner's Guide to Delphi Programming: Chapter 16. Delphi Personal edition does not offer database support. In this chapter, you will find out how to create your own *flat* database and store any kind of data - all without a single data aware component.

Customizing the DBNavigator
Enhancing the TDBNavigator component with modified graphics (glyphs), custom button captions, and more. Exposing the OnMouseUp/Down event for every button.

Database Form Wizard
Developing my own, first Delphi database application, using Database Form Wizard.

Database table to XML and back
Creating XML files from Paradox (or any DB) tables using Delphi. See how to export the data from a table to a XML file and how to import that data back to the table.

Data Searching
Searching for values/records in non-indexed fields. Incremental Searching Part 2

DBGrid with MultiSelect
Multiple row selection in Delphi DBGrid - providing the ability to select multiple records within the grid. A Beginner's Guide to Delphi Database Programming: Appendix A.

Exposing the OnClick event for a DBGrid
Delphi's DBGrid does not respond to the OnClick event. Here's how to hack a DBGrid and surface the OnClick event - using the so-called "protected hack".

Incremental searching
How to add incremental search to your (database) application.

Paradox vs Microsoft Access
This test is to compare various database operations performance on Paradox and Microsoft Access database.

Sorting records in Delphi DBGrid by Clicking on Column Title
How to sort records in Delphi DbGrid by clicking on the column title. Plus: how to change the appearance of the selected column title to reflect the sort order. Even more: how to change the cursor when moving over the DBGrid column titles.

SQL in Delphi
Using Structured Query Language in Delphi.

Using ADO in a Delphi application
Data access using Microsoft's ActiveX Data Objects (ADO) with Delphi.