Appendixes
What follows is a list of articles (quick tips) explaining how to use various Delphi DB related components more efficiently at design and run time.APPENDIX 0
DB Aware Grid Components
The list of the best Data Aware Grid components available for Delphi. The TDBGrid component enhanced to maximum.
APPENDIX A
DBGrid to the MAX
Contrary to most other Delphi data-aware controls, the DBGrid component has many nice features and is more powerful than you would have thought. The "standard" DBGrid does its job of displaying and manipulating records from a dataset in a tabular grid. However, there are many ways (and reasons) why you should consider customizing the output of a DBGrid:
Adjusting DBGrid column widths automatically, DBGrid with MultiSelect
Coloring DBGrid, Selecting and highlighting a row in a DBGrid - "OnMouseOverRow", Sorting records in DBGrid by Clicking on Column Title, Adding components to a DBGrid - theory, CheckBox inside a DBGrid, DateTimePicker (calendar) inside a DBGrid, Drop down pick list inside a DBGrid - part 1, Drop down list (DBLookupComboBox) inside a DBGrid - part 2, Accessing protected members of a DBGrid,
Exposing the OnClick event for a DBGrid, What is being typed into the DBGrid?, How to Display Only Selected Fields in a DbGrid, How to get DBGrid Cell coordinates, How to create a simple database display form, Get the line number of a selected row in a DBGrid, Prevent CTRL+DELETE in DBGrid, How to correctly use the mouse wheel in DBGrid, Making the Enter key work like a Tab key in a DBGrid ...
APPENDIX B
Customizing the DBNavigator
Enhancing the TDBNavigator component with modified graphics (glyphs), custom button captions, and more. Exposing the OnMouseUp/Down event for every button.
Discuss about questions, comments, problems and solutions related to this quick tip!
APPENDIX C
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.
Discuss about questions, comments, problems and solutions related to this quick tip!
APPENDIX D
Enumerating available SQL Servers. Retrieving databases on a SQL Server
Here's how to create your own connection dialog for a SQL Server database. Full Delphi source code for getting the list of available MS SQL Servers (on a network) and listing database names on a Server.
Discuss about questions, comments, problems and solutions related to this quick tip!