Question: This assignment assesses the competency 1. Assemble applications for database access. Directions: For this project, you'll create a form that lets the user maintain technicians

This assignment assesses the competency 1. Assemble applications for database access. Directions: For this project, you'll create a form that lets the user maintain technicians using text box controls. The design of the Technician Maintenance form Technician Maintenance When this application first starts, the data in the first row of the Technicians table is displayed. Then, the user can display the data for other rows using the navigation buttons in the toolbar. To modify an existing row, the user enters the modifications and then clicks the "Save Data" button in the toolbar. To delete an existing row, the user clicks the "Delete" button in the toolbar, followed by the "Save Data" button. To add a new row, the user clicks the "Add New" button in the toolbar, enters the data for the new row, and then clicks the "Save Data" button. This application should handle SQL Server and ADO.NET exceptions. Because the TechID column is an identity column, don't allow the user to change the value in this column. Limit the number of characters that can be entered into the Name, Email, and Phone text boxes so that the entries don't exceed the sizes allowed by the Name, Email, and Phone columns in the database. Compress the entire program for submission. Submit this assignment to your instructor via the dropbox "LP1.2 Assignment: Maintain Technicians." This assignment is worth 40 points and will be graded according to the scoring guide below
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
