Tous nos rayons

Déjà client ? Identifiez-vous

Mot de passe oublié ?

Nouveau client ?

CRÉER VOTRE COMPTE
Visual Basic Database Programming
Ajouter à une liste

Librairie Eyrolles - Paris 5e
Indisponible

Visual Basic Database Programming

Visual Basic Database Programming

Michael Kofler

564 pages, parution le 16/11/2001

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
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:
  • 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
Contents
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
satisfait ou remboursé
Satisfait ou remboursé
Paiement sécurisé
modes de paiement
Paiement à l'expédition
partout dans le monde
Livraison partout dans le monde
Service clients sav@commande.eyrolles.com
librairie française
Librairie française depuis 1925
Recevez nos newsletters
Vous serez régulièrement informé(e) de toutes nos actualités.
Inscription