Waite Group's Visual Basic 6 Client/Server How-To

Description

Visual Basic 6 Client/Server How-To is a practical step-by-step guide to implementing three-tiered distributed slient/server solutions using the tools provided in Microsoft's Visual Basic 6. It addresses the needs of programmers looking for answers to real-world questions and assures them that what they create really works. It also helps to simplify the client/server development process by providing a framework for solution development.

Sample Content

Table of Contents

Introduction.


1. Client/Server Basics.

Discover Client/Server and Other Computing Architectures. Understand File Server Versus Client/Server Database Deployment. Learn about the Two-Tier Versus Three-Tier Client/Server Model. Investigate the Component Object Model. Discover the Service Model. Understand Client/Server Deployments Using Components. Learn More about Client/Server Development Tools Included wth Visual Basic 6. Create a SourceSafe Project.

Display Errors Generated by Remote Data Objects and the RemoteData Control. Write a Connect String. Access Data with the Jet Engine, ODBC, and the Data Control. Make a Connection with the Jet Engine, ODBC, and DAO. Use the SQL passthrough Option. Make a Connection Using the RemoteData Control. Make a Connection Using Remote Data Objects. Benchmark My Connection Options.

Create and Run an SQL Query with RDO. Use RDO to Insert, Update, and Delete Records. Use rdoquery to Parameterize a Query. Control the Number of Rows Returned in a Resultset by RDO. Retrieve Multiple Resultsets with RDO. Perform an Asynchronous Query with RDO. Submit an SQL Query Using ADO. Create a Prepared Statement Using ADO. Parameterize a Query With ADO. Use Transactions with ADO.

Create a Simple MDI Application. Build an Active Toolbar to Simplify Access to Menu Functions. Implement Right Mouse Button Context Menus. Make an Application Drag-and-Drop Capable. Organize Form Contents Using the Tab Control. Load a List or Combo Box with the Results of a Query. Populate an Unbound Grid. Display Calculated Fields in an Unbound Grid. Control the Number of Rows Displayed. Create a Master/Detail Form. Create a Query by Example. Build an HTML Application Interface. Add Activex Controls to the Interface. Place Data on the Web Page.

Utilize the Basics of Object-Oriented Programming. Implement a Basic Class Module. Use a Collection of Classes. Implement an Object Model. Build ActiveX Components. Implement Interfaces. Build an ActiveX Control.

Set Up an ActiveX Business Object Project. Encapsulate Business Rules Into a Class. Encapsulate Business Rules Into an In-Process Server (Activex DLL). Encapsulate Business Rules Into an Out-of-Process Server (Activex EXE). Move My Business Object to a Remote Server. Pass Variant Arrays to And From a Business Object. Encapsulate Business Rules to Run in Microsoft Transaction Server (MTS).

Use the SQL Editing Tools in Visual Basic. Create a Device. Create a Database. Create a Table. Define Primary and Foreign Keys. Index a Table for Efficiency and Performance. Create a Trigger to Control Data Integrity. Create a View. Create and Execute a Stored Procedure. Create a Stored Procedure that Performs a Transaction. Create a Query Using SQL Server Web Assistant. Optimize My Server.

Build a Sample Web Page Using Active Server Pages. Build a Database-Driven Report with Active Server Pages. Create an Active Server Pages Component Using Visual Basic. Build a Multipage Tracking System. Build Reports Based on Ad-Hoc Query Web Pages. Build an Active Server Pages Client/Server Messaging System.

Get Started Building IIS Applications. Build a Simple IIS Application. Build an IIS Application with Class Features. Build an IIS Application-Based Multipage Tracking System. Build an IIS Application-Based Ad-Hoc Query Report. Build an IIS Application-Based Client/Server Messaging System.

Create a Report Using Crystal Reports. Create a Detailed Grouped Report without Crystal Reports. Create a Multiple Query Report Using Word 97 and ActiveX. Create a Pivot Table and Chart Using Excel 97 and ActiveX.

Updates

Submit Errata