New York City College of Technology

CS 708: Client/Server Technologies

	Class Specific Information, Fall 2002, Prof. Moody
	Visual Basic Links
	Tips

Prof. G. Popkin

Course outlines, Dates and coverage of quizzes and exams, Homework assignments for CS101, CS508, CS608, CS708. http://websupport1.citytech.cuny.edu/Faculty/Popkin/Gpopkin.htm

Advanced Programming Using Visual Basic, Version 6.0

Errata, student data files, VB links. See the errata for corrections to the book. http://www.mhhe.com/it/bradley/adv/


The following were issues not listed in the errata.

Page	Location	Change
p. 470	Third bullet	Office XP: Display the HTML Tools Web Tools toolbar.

 

ASP (Active Server Pages) Primer

This Primer Series should give you a good basic understanding of what ASP is all about and get you started on your way to creating your own dynamic web sites. http://www.htmlgoodies.com/ASP/
Download a copy of the ASP primer: ASP-ActiveServerPages.zip

HOW TO: Debug Visual Basic COM Components That Are Used Within Active Server Pages

This step-by-step procedure demonstrates how to debug (or step through) Microsoft Visual Basic (VB) Component Object Model (COM) components that are used within Active Server Pages (ASP) pages. http://support.microsoft.com/default.aspx?scid=kb;en-us;299633

Visual Basic Coding Conventions

Coding conventions are programming guidelines that focus not on the logic of the program but on its physical structure and appearance. They make the code easier to read, understand, maintain, and debug. Coding conventions can include:

• Naming conventions for objects, variables, and procedures.
• Standardized formats for labeling and commenting code.
• Guidelines for spacing, formatting, and indenting.

Also see:
Naming Conventions for Visual Basic: KB Article: Q110264
Object Naming Conventions

PrettyCode.Print

A free tool for easy and pretty printing of Visual Basic source code. http://www.vbcity.com/pcp/

Building Successful Client/Server Applications

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnentdevgen/html/msdn_bldcli~1.asp

HOWTO: Create a DCOM Client/Server Application by Using Visual Basic

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q266717

Using the Windows API to determine version numbers of programs

How to Use Functions in VERSION.DLL. http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q139491

Add a Touch of Web Class to Your Server

HOWTO: Deploy Visual Basic IIS Applications with Package and Deployment Wizard (PDW)

INFO: Deploying WebClasses with the Package and Deployment Wizard

HOWTO: Configure Posting Acceptor to Work with the Package and Deployment Wizard (PDW)

MsgBox Function

Displays a message in a dialog box, waits for the user to click a button, and returns an Integer indicating which button the user clicked.
This page lists the constants that can be used with MsgBox, such as "vbYesNoCancel." When you call the MsgBox function, you can use the MsgBoxStyle enumeration in your code in place of the actual values. Constants are used with the MsgBox function to identify what buttons and icons appear on a message box and which button is the default. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/vafctmsgbox.asp

Dr. GUI on Components, COM, and ATL

Introducion to COM (Component Object Model). http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnguion/html/msdn_drguion020298.asp

Creating Your Own Collection Class: The House of Bricks

The most robust way to implement a collection is by making it a class module. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon98/html/vbconcreatingyourownclasscollectionthehouseofbricks.asp

DevGuru ADO Quick Reference guide

This is an informative 323 page reference source that documents all of the properties, collections, methods, and events for the nine ADO (ActiveX Data Objects) objects and the three RDS (Remote Data Services) objects. Note that two new objects, Record and Stream, were added to ADO with version 2.5. http://www.devguru.com/Technologies/ado/quickref/ado_intro.html

Option Explicit

Declare all variables to save programming time by reducing the number of bugs caused by typos (for example, aUserNameTmp vs. sUserNameTmp vs. sUserNameTemp).

In VB6 go to Tools | Options | Editor tab then turn on "Require Variable Declaration." This should add "Option Explicit" to the General Declarations section of any new modules you create. You can also just type in "Option Explicit" , without the quotes, at the top of the code for each form/module.

App.Path

Avoid having to modify the path in your Visual Basic program, each time you need to run it from a different subdirectory or drive?

Use these steps to make your life easier:

1. Add the following commands to Sub Main() in the main module or to Form_Load() in the main form.
   
      ChDrive App.Path
      ChDir App.Path
   
2. Wherever you have hard coded the full path to a file, remove the path leaving just the filename. For example; Change �C:\Data\VisualBasic\VideoStore.mdb� to �VideoStore.mdb�.
3. Make sure that the file being accessed is in the same location as the project that needs to access it.