Ships from: Skokie, IL
Usually ships in 1-2 business days
Ships from: Marietta, GA
Usually ships in 1-2 business days
Ships from: Chatham, NJ
Usually ships in 1-2 business days
All examples are based on SQL Server 7, and the book also gives detailed information about the Microsoft Data Engine (MSDE), which is ideal for smaller database projects; if required MSDE can be updated to SQL Server without any change of code.
This book:
CD-Rom contains:
| Preface | ||
| Structure of the book | ||
| Pt. I | Introduction | 1 |
| 1 | Quick start | 3 |
| Pt. II | Basics | 21 |
| 2 | Relational databases | 23 |
| 3 | Tools and components | 47 |
| 4 | Transact SQL | 87 |
| 5 | Database design | 131 |
| Pt. III | Programming techniques | 151 |
| 6 | Connection objects | 153 |
| 7 | Recordset objects | 209 |
| 8 | Command objects | 249 |
| 9 | Hierarchical Recordsets | 293 |
| 10 | Database control elements | 307 |
| 11 | Storing linked records | 351 |
| 12 | Input form for linked records | 375 |
| 13 | Internet databases with WebClasses | 445 |
| 14 | SQL Server administration with SQLDMO | 465 |
| 15 | Transfer of database projects | 489 |
| Pt. IV | Reference | 517 |
| 16 | Libraries | 519 |
| 17 | ADO control elements and designer | 539 |
| App. A: The accompanying CD-ROM | 549 | |
| App. B: Bibliography | 553 | |
| Index | 555 |
Admittedly, it looks different in practice: the conception and development of a database application require a wealth of experience, as well as a great deal of patience and nerve. This book aims to make professional database applications more approachable.
As databases cannot be mastered overnight, further clarification is required here: this book is specifically aimed at those programmers who combine Visual Basic with a real client/server database.
All examples, detailed solutions, and programming techniques introduced in this book are based on databases managed with the Microsoft SQL Server 7 or with the Microsoft Data Engine (MSDE). (Much information also applies to Jet databases, but this is included as incidental information only.)
The Microsoft Data Engine requires a special mention at this point: this latest innovation from Microsoft has only been on the market since the launch of Office 2000. Although the MSDE was not marketed with Visual Basic 6 as standard, it was of great significance for all VB programmers: it meant that modern database technology could be used in supporting proportionately small projects. The MSDE is a somewhat limited, yet completely compatible, version of the Microsoft SQL Server. The distinctive feature is that the MSDE may be distributed with programs which were developed with the VB Professional or Enterprise version free of charge!
This is not exclusively a hands-on guide to Visual Basic, quite simply because VB alone is insufficient in developing an efficient client/server application. A special emphasis is therefore placed on the basic principles of the interaction between VB code, the ADO library, and the SQL Server. If you try to increase the efficiency of a VB program by using stored procedures (these are SQL procedures executed by the server), you will immediately recognize why modern VB database development simply is not possible without a basic knowledge of SQL or an understanding of the concepts of relational databases.
This book shows you how to piece together the Microsoft jigsaw puzzle of components, libraries, servers, etc. and apply it in a stable and efficient manner. I wish you the very best of luck!
Michael Kofler
Overview