Use Visual Studio to create a database named Personnel.mdf. The database should have a table named Employee, with columns for employee ID, name, position, and 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 of data into the Employee table.

Create an application that connects to the Personnel.mdf database. The application's main form should display the Employee table in a DataGridView control. The main form should also include the following:

A button that, when clicked displays a second form. The second form should display the Employee table in a Details view. 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 text box which lets the user enter a name and then searches for that name in the Employee table and displays any rows that contain a full or partial match of the specified name

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 to display the entire contents of the dataset and clears the text box for the name search

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 access key

Appropriate naming conventions and data types for any declared variables

Make sure the Tab Order of the form is in logical order