Visual Basic Database Programming Technology and Examples

Author: Zhao Sisi
Publisher:
Publish Date: 2005-05-24
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 and 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: an examination system implemented with ADO+SQL Server, a student course selection system implemented with ADO+SQL Server, a library information system implemented with ADO+SQL Server, and a supermarket management (POS) system implemented with ADO+Access, 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.