Visual Basic Database Programming Techniques and Examples

Author: Zhao Sisi
Publisher:
Publish Date: 2004-06-01
Features: This book provides a detailed introduction to Visual Basic database development technology, with a focus on methods for manipulating Microsoft Access databases and Microsoft SQL Server databases using DAO and ADO objects. The book is divided into two parts, containing 18 chapters. Each chapter in the Basic Part combines specific examples to introduce various techniques frequently used in Visual Basic database programming, including an overview of Visual Basic database development, database installation, creation, and connection, DAO and ADO data/database processing examples, enhanced data processing with SQL, high-performance data processing, graphical display techniques, report printing techniques, control programming tips, binary data processing, data backup/recovery, import/export, design of common functional modules in database systems, and installation program creation. The Comprehensive Examples Part features four complete database systems: ADO+SQL Server for an examination system, ADO+SQL Server for a student course selection system, ADO+SQL Server for a library information system, and ADO+Access for a supermarket management (POS) system, which help readers quickly grasp the essence of complex system design. The book progresses from basic to advanced levels, with detailed explanations from basic database installation to the implementation of comprehensive examples. It includes numerous example source codes, making it suitable not only for beginners learning Visual Basic database development technology but also for experienced Visual Basic database developers as a valuable reference.