Grid and Display

Create a project, called (your initials)Grid, that uses a Grid to show all the information in the Courses table. The Courses table consists of CourseID, Title, StartDate, StartTime, Credits, InstructorID. Use Advanced VB Chapter 3.

• If you are using Visual Basic, create the connection, Table Adapter, and DataSet and assign meaningful names. Test your project, correct errors and save all.
• [If you are not using Visual Basic, give the steps to set-up the connection, Table Adapter, and DataSet. Assign meaningful names to all three.] Write the brief code that the system creates.

Create a project, called (your initials)Display, that would display a “details view” and allow the user to update the Instructors table in bound controls. For this exam, create ONLY Add and Save command buttons and modules and anything else you need for the Add and Save modules to work. Use buttons for record navigation (first, previous, next, last). Include error trapping on database connectivity errors. You don’t want to allow the program to cancel with an exception. The Instructors table consists of InstructorID, LastName, FirstName, Office, PhoneExt.

• Create the form or if you are not using Visual Basic, create a sketch of your form naming each object using the Pascal casing convention.
• If you are using Visual Basic, create the Table Adapter and DataSet. [If you are not using Visual Basic and did #1 above, you don’t need to give the steps of the connection, Table Adapter, and DataSet but just the names you will use in your code.]
• Write the extensive code but ONLY for Add and Save command buttons and modules and anything else you need for the Add and Save modules to work correctly. [If you are not using Visual Basic, for the procedures (methods) that are created automatically with parameters by the system, you just need to write the correct name of the procedure but not all of the parameters—just put parentheses and the abbreviation (etc.).]
• Test your project, correct errors and save all.