1 / 6

Student Information Management System

A VB .Net Windows Application project for students to view, update, and delete personal information at check-in. Connects to the is3001.mdb database file. Extra credit for adding or finding records.

scottjessica
Download Presentation

Student Information Management System

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. HW4 HW4VB .Net Student Database ProjectDue COB Wednesday 18 December 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 = "Provider=Microsoft.Jet.OLEDB.4.0;Data 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").EndCurrentEdit()

  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 Sheetincluding 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.

More Related