Events - Demonstrates various connection events raised by the TSQLConnection component. MetaData - Demonstrates how to obtain simple metadata from a dbExpress connection. DDLSQL - Demonstrates how to send DDL and SQL commands directly to the TSQLConnection component. Trans - demonstrates how transactions are supported in dbExpress. Feedback - Demonstrates how to provide feedback on what is happening in a dbExpress connection. Chapter 2 Basic - Demonstrates basic TSQLDataSet operations. Advanced - Demonstrates more advanced TSQLDataSet methods and operations. Schema - Demonstrates how to use a TSQLDataSet to obtain more detailed metadata from a dbExpress connection. Chapter 3 CDS - Demonstrates basic customer data set support. Navigate - demonstrates how to navigate within a TClientDataSet. CDSIndex - demonstrates how to create and use an index on a TClientDataSet. RangeFilter - Demonstrates how to limit the amount of data in a TClientDataSet by applying ranges and filters. Search - Demonstrates various ways to quickly locate a given record within a customer data set. Chapter 4 EventLog - Demonstrates events raised by TClientDataSet. Updates - Demonstrates how to disable and enable updates of data-aware controls to speed up data set operations. BLOBs - Demonstrates how to store images and annotations in customer data sets. Nested - Demonstrates how a customer data set implements a master/detail relationship. ChangeLog - Demonstrates how to implement undo support using a customer data set. Clone - Demonstrates cloning, which creates a duplicate copy of TClientDataSet. Chapter 5 DataAware - Demonstrates the various data-aware components discussed in this chapter. Chapter 6 Options - Demonstrates the role of various options of TDBGrid. CustomDraw - Demonstrates how to override the TDBGrid's default drawing method to provide an attractive grid. CtrlGrid - A VCL-specific example demonstrating how to use the TDBCtrlGrid component. Chapter 7 Updates - Demonstrates basic operations of the dataset provider. Joins - Demonstrates how to correctly parse data obtained via SQL JOIN. DataFetch - Demonstrates how to limit the number of BLOBs and details returned from a dataset in order to improve application performance. Chapter 8 Methods - Demonstrates how to add callable methods to an application server. LocalConn - Demonstrates how to use multi-tier technologies to implement independently executable database applications. Stateless - Demonstrates how to create a stateless application server for use with MTS and COM+. Chapter 9 ConMan - This complete sample application creates a simple contact management program that demonstrates many of the techniques discussed in this book.