Scenario/Summary
In this lab, we will start with the form that we created in Week 2 (frmPersonnel) and add functionality to INSERT records into a database table and SELECT records for display to the user. We will create a typed dataset, a Data Layer class, several functions to access the data, and a connection to a database.
We also will add a search form to allow the user to search records in the database and display the results of that search.
Please watch the tutorial before beginning the Lab.
Transcript
Deliverables
All files are located in the subdirectory of the project.
The project should function as specified: When you press the Submit button in frmPersonnel, a record should be saved in the tblPersonnel table having the FirstName, LastName, PayRate, StartDate, and EndDate that you entered on the form.
Add a search feature to the project.
Update your main navigation page with the new options. Once you have verified that it works, save your website, zip up all files, and submit it.