Hands on SQL Server 7 With Vb6

by Freeze, Wayne S.

• ISBN13: 9780761513858
• ISBN10: 076151385X
• Format: Paperback
• Copyright: 1999-02-01
• Publisher: Cengage Learning Ptr

Summary

Hands-on tutorials walk readers step-by-step through the development of three client/server applications. The CD-ROM features sample applications with complete source code and test data.

Author Biography

Wayne S. Freeze is a full-time computer book author and computer technology consultant. He has more than 20 years of experience with computers, previously working as the Technical Support Manager for the University of Maryland. His previous books have covered programming in Visual Basic, SQL, and the Internet, and have been featured on Microsoft's MSDN Web site.

Table of Contents

Introduction	xix
Features of SQL Server 7	1	(34)
What Is a Database?	2	(1)
SQL Server 7 Overview	2	(5)
SQL Server Editions	2	(1)
SQL Server Data Types	3	(3)
SQL Server Utilities	6	(1)
SQL Server Architecture	7	(25)
Database Server	8	(1)
Databases	9	(5)
Logins	14	(4)
Users	18	(2)
Tables	20	(4)
Indexes	24	(2)
Views	26	(1)
Accessing a Database	27	(5)
Stored Procedures	32	(1)
Wrapping Up	32	(3)
Fundamentals of Database Programming Using Visual Basic	35	(48)
Database Programming Overview	36	(2)
The Database Designer	38	(11)
The Data Environment	38	(2)
The Data View Window	40	(9)
Data-Bound Controls	49	(17)
The ADO Data Control	50	(4)
The Data-Bound Controls	54	(12)
Accessing Databases with ActiveX Data Objects	66	(15)
The ADO Object Model	66	(15)
Wrapping Up	81	(2)
Project 1 The Customer Information Subsystem	83	(102)
Project Overview	84	(1)
What Is the Customer Information Subsystem?	85	(4)
Database Elements	86	(2)
Application Functions	87	(1)
The Data Elements	87	(1)
Wrapping Up	88	(1)
Gathering Data for the Customer Information Subsystem	89	(14)
Determining the Data Elements Needed	90	(9)
The Brainstorming Session	91	(1)
Reviewing the Results	91	(8)
Determining the Functions Needed	99	(3)
Types of Users	99	(3)
Wrapping Up	102	(1)
Designing the Customer Information Subsystem	103	(28)
Designing the Database	103	(4)
Relational Database Concepts	103	(1)
Normalization	104	(1)
Entity/Relationship Modeling	105	(2)
Designing the Customer Information Subsystem Database	107	(7)
The Customer Information Subsystem Attributes	107	(2)
The Customer Information Subsystem Entities	109	(1)
The Final Database Design	110	(4)
Building the Database	114	(14)
Creating the Tables	115	(2)
Building the Triggers	117	(2)
Creating Check Constraints	119	(1)
Creating Indexes	120	(2)
Creating the Database Diagram	122	(1)
Adding Foreign Keys	123	(1)
Saving the Database Structure	124	(4)
Designing the Functions Needed	128	(1)
The Customer Information Form	128	(1)
Customer Export Function	128	(1)
Backup and Recovery Functions	129	(1)
Wrapping Up	129	(2)
Building the Customer Information Subsystem	131	(36)
The Customer Information Form	131	(18)
Adding the Tools to the Toolbox	132	(2)
Configuring the ADO Data Control	134	(4)
Binding Controls to the ADO Data Control	138	(3)
Adding Other Functions to the Program	141	(8)
Exporting Customer Data to Excel	149	(7)
Building the DTS Package	150	(4)
Running Your DTS Package	154	(2)
Backing Up Your Data	156	(9)
Types of Backups	156	(2)
Databases on Your Server	158	(1)
Optimizing Your Database	159	(1)
Using the Database Maintenance Plan Wizard	160	(5)
Wrapping Up	165	(2)
Testing the Customer Information Subsystem	167	(18)
Loading the Sample Data	167	(5)
Testing the Edit Customer Information Program	172	(3)
Running and Testing the Program for the First Time	172	(2)
Testing Like a User	174	(1)
Testing the Export Function	175	(1)
Testing the Database Backup	176	(4)
Reviewing the Reports	176	(1)
Reloading the Database	177	(3)
Wrapping Up	180	(5)
Project 1 Summary	183	(2)
Project 2 The Inventory Information Subsystem	185	(176)
Project Overview	186	(1)
What Is the Inventory Information Subsystem?	187	(6)
Describing the Inventory Information Subsystem	188	(2)
Database Elements	188	(1)
Application Functions	188	(1)
Types of Users	189	(1)
Goals of the Inventory Information Subsystem	190	(1)
Determining Data Element Needs and Structures	190	(1)
Building Programs to Access the Database	191	(1)
Wrapping Up	191	(2)
Gathering Data for the Inventory Information Subsystem	193	(10)
Determining the Data Elements Needed	193	(7)
The Brainstorming Session	194	(1)
Reviewing the Results	194	(6)
Determining the Functions Needed	200	(1)
Wrapping Up	200	(3)
Designing the Inventory Information Subsystem	203	(20)
The Inventory Information Subsystem Attributes	203	(8)
The Inventory Information Subsystem Entities	204	(4)
The Final Database Design	208	(3)
Building the Database	211	(11)
Creating a Database Diagram	212	(1)
Adding a Table to the Diagram	212	(2)
Linking Tables Together	214	(2)
Building Full-Text Indexes	216	(5)
Creating Triggers	221	(1)
Finishing Up the Database	222	(1)
Wrapping Up	222	(1)
Building the Inventory Information Subsystem	223	(106)
Using Data Environments in Visual Basic	224	(10)
Adding a Data Environment to Your Program	224	(1)
Adding a Connection Object to the Data Environment	224	(3)
Adding a Command Object to the Data Environment	227	(1)
Tuning the Command Object's Cursor, Locking, and Cache	228	(2)
Building a Login Form	230	(2)
Closing the Database Connection	232	(2)
Programming with the Data Environment Designer	234	(26)
Adding Columns to Your Form the Easy Way	234	(2)
Navigating the Books Table Manually	236	(9)
Refreshing Your Recordset	245	(1)
Filtering for Results	246	(2)
Adding a Book to the IIS Database	248	(2)
Adding Authors to the AuthorBooks Table	250	(8)
Editing Binding Codes	258	(1)
Changing Publishers	259	(1)
An Introduction to Creating IIS Applications with Visual Basic	260	(17)
Accessing the IIS Application	261	(1)
State Management	262	(2)
IIS Application Object Model	264	(13)
Create Your First IIS Application	277	(5)
A Brief Introduction to HTML Tags	282	(9)
Building an IIS Application for WebBooks.com	291	(27)
Displaying the WebBooks.com Home Page	293	(17)
Displaying the WebBooks.com Book Information Page	310	(8)
Adding Search Capabilities to WebBooks.com	318	(8)
Displaying Books by a Particular Author	318	(3)
Entering Search Information	321	(1)
Running the Search	322	(4)
Wrapping Up	326	(3)
Testing the Inventory Information Subsystem	329	(32)
Loading the Sample Data	330	(1)
Considerations for Loading the Sample Data	330	(1)
The Good, the Bad, and the Ugly	331	(17)
The Data File	331	(4)
A Detailed Look at the Import Program	335	(11)
The Big Subroutine	346	(2)
Testing the Book Information Program	348	(4)
Testing the WebBooks.com Web Application	352	(5)
Wrapping Up	357	(4)
Project 2 Summary	359	(2)
Project 3 The Order Processing Subsystem	361	(154)
Project Overview	362	(1)
What Is the Order Processing Subsystem?	363	(6)
Describing the Order Processing Subsystem	364	(2)
Database Elements	364	(1)
Application Functions	364	(1)
Types of Users	365	(1)
Goals of the Order Processing Subsystem	366	(2)
Determining Data Element Needs	366	(1)
Designing the Database Structures	367	(1)
Building Programs to Access the Database	367	(1)
Wrapping Up	368	(1)
Gathering Information for the Order Processing Subsystem	369	(8)
Determining the Data Elements Needed	369	(6)
The Brainstorming Session	370	(1)
Reviewing the Results	370	(5)
Determining the Functions Needed	375	(1)
Adding Books to the Shopping Cart	375	(1)
The Checkout Process	375	(1)
Packing the Books for Shipment	375	(1)
Reordering Books	375	(1)
Wrapping Up	376	(1)
Designing the Order Processing Subsystem	377	(14)
Designing the Order Processing Subsystem Database	378	(8)
The Order Processing Subsystem Attributes	378	(1)
The Order Processing Subsystem Entities	378	(3)
The Final Database Design	381	(5)
Designing the Functions Needed	386	(3)
Ordering a Book	386	(1)
Placing the Order	387	(1)
Tracking the Order	388	(1)
Processing the Order	388	(1)
Receiving New Books at the Warehouse	388	(1)
Analyzing the Data for Trends	389	(1)
Wrapping Up	389	(2)
Building the Order Processing Subsystem	391	(86)
Implementing the Ability to Order Books Online	392	(73)
The Bug Fixes	393	(6)
Approaches to Allowing the Placement of Orders Online	399	(1)
Implementing the Ability to Log in to the Web Site	399	(11)
Adding a Book to the Shopping Cart	410	(1)
Adding Shopping Carts	410	(28)
Building Utility Functions	438	(14)
Using the CDONTS to Send Mail	452	(13)
Performing Warehouse Functions	465	(9)
The Microsoft Data Report Designer	465	(9)
Wrapping Up	474	(3)
Testing the Order Processing Subsystem	477	(18)
Testing the WebBooks.com Application	477	(14)
Verifying the Old Application	478	(2)
Verifying the Login Process	480	(3)
Registering for the First Time	483	(2)
Ordering a Book	485	(1)
Viewing the Big Shopping Cart	486	(5)
Assigning a Tracking Number and Printing the Packing List	491	(1)
Wrapping Up	492	(3)
Project 3 Summary	493	(2)
Beyond WebBooks.com	495	(10)
Improving WebBooks.com	495	(3)
Using Keywords and Categories	495	(1)
Alternate Ways to Find Books	496	(1)
More Use of E-mail	496	(1)
Ratings and Rankings	497	(1)
A Complex Database	497	(1)
Application Design Philosophies	498	(2)
Client/Server Application vs. IIS Applications vs. DHTML Applications	498	(1)
Stored Procedures vs. Application Server vs. Client Application	499	(1)
Exploiting Other Tools and Technologies	500	(4)
Using VBScript in the Client	500	(1)
Using a Secure Server	500	(1)
Using Office Components	501	(1)
Analyzing Information with OLAP	501	(1)
Using Microsoft Transactions Server	502	(1)
Creating Help Files	502	(1)
Microsoft Agent	503	(1)
Wrapping Up	504	(1)
Building DHTML Programs	505	(10)
What Is a DHTML Application?	505	(7)
Building the DHTML Program	506	(6)
Testing the DHTML Application	512	(2)
Wrapping Up	514	(1)
Appendix What's On the CD-ROM?	515	(8)
Glossary	523	(8)
Index	531