Craig Persiko's CS 112D class

Click Here for Contact Information, Office Hours

What's New

• Your semester grades are posted here (as of 12/23)

Miscellaneous Information:

• Your semester grades are posted here (as of 12/23)
• Semester Schedule, including test dates and holidays, etc.
• Course Procedures and Information
• Links to recommended software and info for students

Assignments:

• Practice Problem 1: Retirement Calculator due Thursday, 8/24. Solution available here
• Practice Problem 2: Database Setup is due Thursday, 8/31 Solution available here
• Practice Problem 3: Employee Name Viewer is due Thursday, 9/7 VB.NET version 2003 solution available here and VB.NET version 2005 solution available here
• Programming Lab 1: Employee Records Viewer is due Thursday, 9/21 Solution available here
• Programming Lab 2: Employee Records Input is due Thursday, 9/28 Solutions available here: Regular credit version and Extra credit version
• Programming Lab 3: Course Schedule Input/Display is due Thursday, 10/5 Solutions available here: lab3 solution which includes regular and extra-credit projects
• Practice Problem 4: 2-Table Course Schedule Input/Display due Thursday, 10/12 Solution available here
• Programming Lab 4: Inventory Grid due Thursday, 10/26 Solutions available here: zipped solution and Stored Procedure code generated by DataAdapter wizard. Extra Credit solution
• Programming Lab 5: Strongly-typed Customer DataSet with Filtering is due Thursday, 11/2 Solution available here: zipped solution
• Programming Lab 6: Employee Data Program (Data-Bound in code) is due Thursday, 11/9 Solution available here: zipped solution with partial extra credit Solution available here: zipped solution with better extra credit (from past student)
• Practice Problem 5: Access/Oracle Data Program (Data-Bound with Typed DataSet) is due Tuesday, 11/21 Solutions available here: VB 2003 version and VB 2005 version
• Practice Problem 6: Reading/Writing XML files is due Thursday, 11/30 Solution available here
• Programming Lab 7: Crystal Reports, due Thursday 12/7 Solutions available here: VS.NET 2002 solution and VS.NET 2003 solution. Here's the extra credit solution in VS.NET 2003 format.

Class Notes:

• Prerequisite Examples
• Visual Basic .NET Basics
• Object-Oriented Programming (OOP)
• MSDE Basics and VS.NET Database Projects (Chapter 3 up to page 91 and Chapter 8)
• Database Basics with VB.NET (Chapter 1)
• SQL Server Queries and Commands (Chapter 2)
• SQL Server Part 2 (Chapter 3 after page 91)
• Data Providers (Chapter 4 part 1)
• The Command Classes (Chapter 4 part 2)
• Exceptions
• Arrays
• The DataSet Class (Chapter 5 part 1)
• DataSet Table Relations, Using DataSet Component (Chapter 5 part 2)
• Review for Test #2
• Using DataAdapter to Populate DataSet from Database (Chapter 6 part 1)
• Using DataAdapter to Update Database from DataSet (Chapter 6 part 2)
• Using DataAdapters and DataGrids with Multiple Related Tables (Chapter 6 part 3)
• Concurrency Conflicts, DataViews, and Typed DataSets (Chapter 7)
• TableAdapters (new for VB 2005)
• Data Binding (Handout)
• Connecting to Oracle and Access Databases (Handout)
• XML Basics (Chapters 9 and 10)
• Introduction to Crystal Reports

Sample Programs:

• Prerequisite Examples
• Tutorial 5 Template from Simply Visual Basic .NET by Deitel, Deitel and Nieto. This is used with the photocopy that starts "Introducing Visual Basic .NET Code"
• Command Examples: Demonstrates how to use Command objects to access DB
• Transaction Example project
• Transaction example from class 9/20 (very messy)
• Simple DataSet example using just one table in memory
• The DataSets solution from the text book contains lots of example DataSet and DataAdapter code
• Business Case 6 example of using DataAdapters with DataSet that combines multiple related tables. (Many customers don't have any orders in the database, but customers 4, 5, and 6 do, so they are good examples to view)
• Typed DataSet Demo project, similar to Lab 5
• Data Binding in Code Demo project, similar to Lab 6
• Modification of Lab 4 solution done in class 10/30 to use a typed dataset and databinding setup at design-time
• TableAdapter Example variation of Lab 4 done in class 11/1
• Here is a zip file containing a project that connects to the Miscrosoft Access "Northwind" sample database This example also uses a typed DataSet with two DataTables that have a foreign key relationship.
• Microsoft Access "Northwind" sample database for use with these examples and pp5
• Here is a variation of the above done in VB 2005 (done in class 11/8)
• XMLDomSample project from the textbook
• ADO-XML project from book. This project uses the pubs database, which can be setup from the instpubs.sql script file which is in your SQL Server installation directory.
• Here is a self-extracting (run it to extract files) zip file containing a project that uses Crystal Reports (downloaded from the Deitel book web site)
• Crystal Reports Project Example for VB 2003
• Crystal Reports Template project done in VB 2005 in class 12/4
• Crystal Reports Example done in VB 2005 in class 12/6

Last updated: 12/23 11:10am