Question
Use Visual Studio 2017 to create a database named Personnel.mdf. The database should have a table named Employee, with columns for employee ID, name, position,
Use Visual Studio 2017 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. Insert at least 10 sample rows of data into the Employee table. The applications main form should display the Employee table in a DataGridView control. The main form should also have a button that, when clicked, displays a second form. The second form should display the Employee table in a Details view. Add the following buttons to the Main form: 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, searches for the name in the Employee table. (the user should specify a name in a text box and then). Note: the application should display 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. A button that, when clicked, displays a message indicating the lowest (minimum) pay rate in the table. A button that, when clicked, displays the average pay rate for all employees. A button that, when clicked, will add a new Employee to the Table. A button that, when clicked, will delete selected Employee from the Table.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started