Practice Problem 5: Access/Oracle Data Program (Data-Bound with Typed DataSet), due Tuesday, 11/21

Objective: To write a program using data-bound controls to manipulate a pair of related Microsoft Access or Oracle tables, using a typed DataSet

• Write a program to allow the user to view, enter and save Category and Product data like shown here:

  

• Your program should connect to a Microsoft Access or an Oracle database.
• You should use the Categories and Products tables that come with the Northwind sample database that comes with Microsoft Access, or create your own tables containing the fields shown above. Only a handful test records are needed, and no other tables are needed. The primary key fields should be set as identity/auto-increment fields.
• Here's the Microsoft Access "Northwind" sample database in case you don't already have it.
• Don't drag and drop anything from the Server Explorer onto your form
• In VB 2003, use the OleDbDataAdapter control from the Data tab of the Toolbox, with its Configuration Wizard. Then use the "Generate DataSet" command to generate a typed DataSet and add it to your form's designer window (like you did for Lab 5)
• Add the TextBoxes, Labels, and Buttons to your form, and set the Data properites of your TextBoxes to make them data-aware.
• Your buttons should of course behave as expected, like in Lab 6.
• To save changes in the current record as well as previously changed records, call the CurrencyManager's EndCurrentEdit() method before calling the DataAdapter's Update() method.
• In VB 2005, you can do this using the Data Sources window and dragging and dropping from it. However, your interface needs to look like above (delete the BindingNavigator).
• When turning in your homework, turn in a zip file containing your entire solution.

Return to main CS 112D page