HW4 VB 'Net Student Database Project Due COB Wednesday 18 December

1
HW4VB .Net Student Database ProjectDue COB
Wednesday 18 December
HW4
IS3001 George Zolla
Naval Postgraduate School
Monterey, CA
2
HW4 Requirements

• 1. Write a VB .Net Windows Application project
  that allows a new student to use a VB Form to
  view and modify personal information in a
  database during check-in at the Naval
  Postgraduate School. The project will allow the
  student to View, Update and Delete any record.
  The is3001.mdb database file, available on the
  course web page, shall be used to connect to the
  form. Extra credit will be given if the project
  enables the user to add or find records.

3
HW4 Requirements

• 2. Code similar to the following must be used in
  the Form_Load sub procedure to automatically
  connect the form to the database file
•  
• OleDbConnection1.ConnectionString
• "ProviderMicrosoft.Jet.OLEDB.4.0Data Source
  is3001.mdb"
•  
• Note Make sure the is3001.mdb file is in the
  "bin" project folder.

4
HW4 Requirements

• 3. Code similar to the following must be used in
  the Update sub procedure prior to the data
  adapter update method to successfully update the
  database file

Me.BindingContext(DsStudents1,Students").EndCurre
ntEdit()
5
HW4 Requirements

• 4. The following fields must be displayed on the
  form
• First Name
• Last Name
• Rank
• Service
• Designator
• Country
• Curriculum (Number)
• Status (Student, Staff or Faculty)
• PRD
• Sex

6
HW4 Requirements

• 5. Use the conventions recommended in the text
  and the guidance and requirements contained in
  the Project Evaluation Sheet including project
  submission instructions. Plus
• Use meaningful names for controls, variables and
  the form
• Images may be used to enhance the visual
  effectiveness
• The database file must be located in the project
  bin folder.