Question: I need a detailed step by step process on how to do this in Visual Studio. Use Visual Studio to create a database named Personnel.mdf.

 I need a detailed step by step process on how todo this in Visual Studio. Use Visual Studio to create a database

I need a detailed step by step process on how to do this in Visual Studio.

Use Visual Studio to create a database named Personnel.mdf. In the Personnel.mdf database, create a table named Employee, with columns (fields) for employee ID, name, position, and hourly pay rate using appropriate data type. To minimize issues related to column (field) names, avoid the use of spaces in column (field) names. Use camelCase notation or separate multiple words with underscores (e.g., HourlyPayRate or Hourly_Pay_Rate). The employee ID should be the primary key and be automatically generated (hint: change the Identity Specification properties appropriately). Insert at least five sample rows (records) of data into the Employee table. Create an application that connects to the Personnel.mdf database. The application's main form (use a descriptive name) should display the rows (records) of the Employee table in a DataGridView control. It should include the navigation tool bar to allow navigation, adding, deleting, and saving rows (records). The main form should also include the following: A Button that, when clicked, displays a second form (use a descriptive name). The second form should display the rows (records) in the Employee table in a Details view control. The second form should include the navigation tool bar to allow navigation, adding, deleting, and saving rows (records). It should also include a Button to close the form. Make sure that when the second form is closed, the main form refills the dataset so the most current data is displayed. A Button that, when clicked, sorts the data in ascending order by hourly pay rate A Button that, when clicked, sorts the data in descending order by hourly pay rate A Button that, when clicked, displays a message indicating the highest (maximum) pay rate in the table using a Message Box. A Button that, when clicked, displays a message indicating the lowest (minimum) pay rate in the table using a Message Box. A Button that, when clicked, resets the DataGridView control on the main form to display the entire contents of the Employee table and clears the Text Box for the name search and then sets the focus to the Text Box. This Button should be assigned to the CancelButton property of the main form. A Text Box which lets the user enter a name as a search term. A Button that, when clicked, searches for the name entered into the Text Box within the Employee table and displays all rows (records) which contain a full or partial match of the entered name. Clear the Text Box control and set focus to the Text Box. Input validation should be implemented to make sure a name is entered into the Text Box (i.e., it cannot be blank); otherwise, an error message should be displayed in a Message Box and focus returned to the Text Box. This Button should be assigned to the AcceptButton property of the main form. A Button that, when clicked, exits the application The program must include standard features of a Windows application including: Change the Text property of forms (do not simply use the default form name) Forms should have descriptive names since this is a multiform project Appropriate naming conventions for all controls Buttons with appropriate name and keyboard access key Appropriate naming conventions and data types for any declared variables Make sure the Tab Order of the form is in logical order Remove any unused event handlers from the program code . The design of the forms is up to you, but must include the required controls and functionality. Sample Forms and Output are provided below: Main form Show Details Personnel (1 of 5 + X Employee ID Name 1 Dak Prescott 2 Zeke Eliot 3 Jason Whitten 4 Terrence Williams 5 Jason Garrett Position Quarterback Running Back Hourly Pay Rate 50 0000 75.0000 45.0000 35.0000 25.0000 Sort Hourly Pay Rate Ascending Tight End Sort Hourly Pay Rate Descending Receiver Coash Maximum Hourty Pay Rate Minimum Housty Pay Rate Beset Enter Name: Search Name Error Message Second form Personnel Details of 5 + X x Name cannot be blank. Please renter. Name: OK Employee ID: Dak Prescott Position: Quarterback Hourly Pay Rate: 50.0000 Close Message Box for Maximum Hourly Pay Rate Message Box for Minimum Hourly Pay Rate Maximum Hourly Pay Rate is: $75.00 Minimum Hourly Pay Rate is: $25.00 OK OK

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!