Résumé
If you are a Visual Basic programmer, this book will
provide you with all the practical advice you need to
master working with databases on client/server systems.
Using real-life examples, this book provides a thorough and
detailed introduction to ADO (ActiveX Data Objects) and to
the various database productivity tools integrated into
Visual Basic. It also offers a wealth of practical guidance
on programming techniques allowing access to database
servers such as MSQL Server. The book covers:
- Different Ado cursor types
- The advantages of stored procedures
- Application of ADO controls
- Distribution of VB database applications
- Internet access via WebClass objects
- Compact reference of ADO 2.1 objects and controls
- Deals with problems as they appear in the real world, not as they are documented by Microsoft
- Explains practical techniques which will optimize database performance
- Provides guidance on dealing with problems encountered during with MSDE deployment
- Introduces database administration using the SQLDMO library
- Preface
- Structure of the book
- I: INTRODUCTION
- 1: Quick Start
-
- The pubs database
- Displaying sales figures
- The Data Environment designer
- Displaying an alphabetical title list
- Displaying sales figures per title
- Entering sales figures
- II: BASICS
- 2: Relational databases
-
- What is a database?
- Brief database glossary
- Features of relational databases
- Basics
- Sample databases
- Realization of database systems
- Jet vs SQL Server, Access vs VB
- Jet engine vs SQL Server/MSDE
- Access vs Visual Basic
- 3: Tools and components
-
- Libraries and control elements
- ADO library
- ADO versions and supplements
- Control elements
- Designers
- Visual Basic development environment
- Visual Data Manager (VisData)
- Data view window (DataView)
- Wizards
- TSQL Debugger
- SQL Server and MSDE
- Versions and licenses
- Tools
- Microsoft Data Engine (MSDE)
- External programs and servers
- Access, Jet engine, Upsizing Wizard
- Internet Explorer
- Internet Information Server (IIS)
- Microsoft Transaction Server (MTS)
- Microsoft Message Queue (MSMQ)
- Crystal Reports
- 4: Transact SQL
-
- Introduction
- Data queries (SELECT)
- Syntax basics
- Combining data from several tables (INNER JOIN)
- Data grouping (aggregate functions)
- Reducing results lists
- Character strings, date, special characters
- Syntax summary
- Data changes (INSERT, UPDATE, DELETE)
- Making new tables (SELECT INTO)
- Inserting records (INSERT)
- Changing records (UPDATE)
- Deleting records (DELETE)
- Syntax summary
- SQL procedures (stored procedures)
- Syntax
- Examples
- Triggers
- Basics
- Examples
- 5: Database design
-
- Introduction
- Designing a database outline
- SQL Server data types
- SQL Server options
- SQL Server user administration
- The alpbiblio database
- Views and SQL procedures
- III: PROGRAMMING TECHNIQUES
- 6: Connection objects
-
- Basics
- Introductory examples
- ADO code
- Adodc
- DataEnvironment
- ConnectionString parameter
- General connection information
- Choice of the OLE DB driver (Provider)
- Settings for the SQLOLEDB SQL Server driver
- Settings for the ODBC Provider MSDASQL
- Settings for the Jet driver
- Properties of the Connection object
- Connection and Adodc properties
- DEConnection features
- Additional properties
- Error prevention
- ADO code (SQLOLEDB)
- ADO code (MSDASQL/ODBC)
- Adodc (SQLOLEDB)
- DataEnvironment (SQLOLEDB)
- Asynchronous establishment of a connection
- DataLink files
- Using DataLink files in VB programs
- OLE DB Service Component library (MSDASC)
- Transactions
- Error enumeration
- Administration of connections and resources
- 7: Recordset objects
-
- Basics
- Record fields (fields)
- Navigation in lists of records
- Modifying records
- Locking, cursor type, and other Recordset properties
- Client- and server-side cursors
- Cursor types
- Locking
- Possible Recordset types with the SQL Server (SQLOLEDB driver)
- Special settings
- Cursor alternatives
- Sample program
- Features of client record sets
- Sorting records
- Filter Recordset filters
- Batch update
- Recordsets without database
- Saving Recordset objects in XML files
- 8: Command objects
-
- Basics
- Introductory example
- Command properties
- Execute method
- Requests with parameters
- Compiled queries (Prepared property)
- Invocation of SQL procedures (stored procedures)
- Asynchronous queries
- Executing asynchronous queries
- Constructing Recordsets asynchronously
- Design of Command objects in the DataEnvironment designer
- Operating designer
- SQL Generator
- SQL procedures
- Parameter options
- Using DE objects in the program code
- TSQL Debugger
- 9: Hierarchical Recordsets
-
- Introduction
- SQL syntax for hierarchical Recordsets
- Creating hierarchical Recordsets using the DataEnvironment designer
- Internals
- 10: Database control elements
-
- Bound standard control elements
- Basics
- Programming techniques
- Formatting (DataFormat)
- List boxes (DataList/DataCombo)
- Table boxes (DataGrid/MSHFlexGrid)
- DataGrid
- MSHFlexGrid
- 11: Storing linked records
-
- Linked records in relational databases
- Test scenario
- Variation 1: Recordset objects
- Variation 2: SQL procedures (SPs)
- Working with Recordsets on an SP basis
- Results
- Inserting records using GUIDs
- Variation 1: Recordset objects, server GUIDs
- Variation 2: Recordset objects, client GUIDs
- Variation 3: SQL procedures (SPs), server GUIDs
- Variation 4: SQL procedures (SPs), client GUIDs
- Producing GUIDs in the VB program
- 12: Input form for linked records
-
- Overview
- Operation
- Basics
- Program structure
- Global variables and auxiliary functions
- Code for evaluating the search mask
- Code for displaying the search results
- Code for managing the entry mask
- General management
- Managing the DataGrid control element (authors)
- Reading a record
- Entering a new record
- Saving a record
- Deleting a record
- Pros and cons of bound control elements
- 13: Internet databases with WebClasses
-
- Introduction
- Searching titles in the alpbiblio database
- Code
- Status management
- Database login
- HTML code
- VB code
- 14: SQL Server administration with SQLDMO
-
- Introduction
- SQL Server administration
- SQLDMO library
- Establishing a connection
- Sample program
- Creating login and user
- Programming techniques
- Program code
- Backing up
- Program technology
- Sample program
- 15: Transfer of database projects
-
- Introduction
- Client installation
- Creating installation programs (developer's view)
- The installation process (user's view)
- Internals of the installation process
- Database installation
- Basics
- Database transport with detach and attach
- Installing the database with a VB program
- Changing the password
- MSDE installation
- Basics
- Installing MSDE with a VB program
- Conclusion
- IV: REFERENCE
- 16: Libraries
-
- ADODB library
- Object hierarchy
- ADODBConnection
- ADODBRecordset
- ADODBField
- ADODBCommand
- ADODBParameter
- ADODBError
- ADODBProperties
- MSDASC library
- SQLDMO library
- WebClassLibrary library
- 17: ADO control elements and designer
-
- DataEnvironment designer
- Adodc database field
- Bound standard control elements
- StdDataFormat object
- DataList and DataCombo list boxes
- DataGrid table fields
- MSHFlexGrid - table field
- Appendix A: The accompanying CD-ROM
- Appendix B: Bibliography
- Index
L'auteur - Michael Kofler
Michael Kofler : Docteur en informatique diplômé de l'Université de Graz en Autriche, Michael Kofler est l'auteur de nombreux ouvrages à succès sur Visual Basic, Visual Basic.NET, Linux, etc.
Michael Kofler holds a Ph.D. in computer science from Graz Technical University. He has written a number of successful computer books on topics such as Visual Basic, Visual Basic .NET, and Linux. Michael is the author of The Definitive Guide to MySQL 5, Third Edition and Definitive Guide to Excel VBA, Second Edition from Apress.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Addison Wesley |
| Auteur(s) | Michael Kofler |
| Parution | 16/11/2001 |
| Nb. de pages | 564 |
| Format | 19 x 24 |
| Couverture | Relié |
| Poids | 1200g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780201721935 |
Avantages Eyrolles.com
Livraison à partir de 0,01 € en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
