PRG 240 - Class # 5 Lecture

Return last week's quizzes.

Continue to discuss Ch. 3.

• Execute and review the Ch03SBS1 project from the Student CD-ROM.
  
  
  • Examine the code for this project.
• What is the name of the ADO data control?
• What data-bound controls are being used?
  
  
• Execute the Ch03SBS2 project (see pp. 108-109) from the CD-ROM.
  • You may have to change them from read-only.
  • Make any necessary modifications to the Connection string for the ADO data controls so that you can execute the project.
  • This project is supposed to look like the Figure 3.17 diagram on p. 108. This project from the CD-ROM should use the next record buttons for the data controls rather than command buttons to navigate the database. (I think the author mistakenly copied Ch03SBS3 overtop of Ch03SBS2.) If we have time, lets copy Ch03SBS1 and modify it into a correct version of Ch03SBS2.
  • Notice that there is virtually no associated code with this project.
  • If necessary & if time is available, let's study the DataCombo control properties in Step #5 on p. 109.
    
    
• Do Feedback 3.2 on p. 109 as a class.
  
  
• Execute the Ch03SBS3 project (see pp. 111 & 112) from the CD-ROM.
  • You may have to change them from read-only.
  • Make any necessary modifications to the Connection string for the ADO data controls so that you can execute the project.
  • This is the project as described in the Figure 3.18 diagram on p. 111.
    
    
  • Examine & discuss the code for this project. Notice the code within the command buttons that provide for navigation of the database.
    
    
• Discuss "moving a project" as described on pp. 113 & 114.
  • What is the App object?
  • How is the App.Path property being used in the ConnectionString for adoPatients?
    
    
• (OPTIONAL) Execute the Ch03ADODataGridSBS project (see pp. 115-118) from the CD-ROM.
  • You may have to change them from read-only.
  • This is the project as described in Figure 3.19 on p. 115.
    
    
  • Examine & discuss the code for this project.
    • Notice the use of the general sub procedure SetRecordNumber
      
      
• Execute the Ch03DE1 project (see pp. 122-123) from the CD-ROM.
  • This is the project as described in the Figure 3.25 diagram on p. 123.
  • (if time) Create your own practice copy of this project in class.
  • (if time) Examine & discuss the little bit of code that is associated with this project.
    
    
• (IF TIME) Execute the Ch03DE2 project from the CD-ROM
  • Examine & discuss the code to this project.
    

Homework Assignment:

• Finish the Ch. 2 VB Auto Center case study on p. 92 by Mar 12. This project will be due on a floppy dis labelled with your name and "Ch. 2 VB Auto Center". The code for each form should also be printed out and stapled with the parent form on top. You will have to create your own fictitious data for the ListView on the Auto Inventory form. Add a popup (shortcut) menu of some kind (it can be simple).
• Review and execute the Ch. 3 Advanced Vision and Beyond project (can be found on the Student CD-ROM) if you haven't done so already.
• Do Programming Exercise 3.1 on p. 155. This will not be graded but you should have most of it working. An upcoming quiz (probably on 3/19) will require you to build a similar project.
• Do Programming Exercise 3.2 on p. 155. This is a second priority. If you do not have this finished we will work on it in class next week.
• Begin Ch. 3 VB Auto Center on p. 156. This will eventually be a graded assignment.