Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microsoft Visual Basic 2005 For Windows Mobile Web Office And Database Applications Comprehensive

Authors: Gary B. Shelly, Thomas J. Cashman, Corinne Hoisington

1st Edition

0619254823, 978-0619254827

More Books

Students also viewed these Databases questions

Question

6. How would you design your ideal position?

Answered: 1 week ago

Question

2. How do they influence my actions?

Answered: 1 week ago