Use Visual Studio 2017 to create a database named Personnel.mdf.The database should have a table…

Use Visual Studio 2017 to create a database named Personnel.mdf.The database should have a table named Employee, with columns foremployee ID, name, position, and hourly pay rate. The employee IDshould be the primary key. Insert at least 10 sample rows of datainto the Employee table. The application’s main form should displaythe Employee table in a DataGridView control. The main form shouldalso have a button that, when clicked, displays a second form. Thesecond form should display the Employee table in a Details view.Add the following buttons to the Main form: A button that, whenclicked, sorts the data in ascending order by hourly pay rate. Abutton that, when clicked, sorts the data in descending order byhourly pay rate. A button that, when clicked, searches for the namein the Employee table. (the user should specify a name in a textbox and then). Note: the application should display any rows thatcontain a full or partial match of the specified name. A buttonthat, 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 thetable. A button that, when clicked, displays the average pay ratefor all employees. A button that, when clicked, will add a newEmployee to the Table. A button that, when clicked, will deleteselected Employee from the Table.

PLACE YOUR ORDER TO GET STARTEDThe post Use Visual Studio 2017 to create a database named Personnel.mdf.The database should have a table… appeared first on Essay Gem.

"Order a Custom Paper on Similar Assignment! No Plagiarism! Enjoy 20% Discount"