Homework 11

Ø Make a new WinEmployee program that uses ADO.NET.

o (30) The Employee and BonusInfo should be loaded from the supplied Access Employ.mdb, or from a comparable SQL Server 2000 database, into appropriate datagrids.

o (20) The JobID relationship should be supported upon request. The “master- detail” should show all employees elegible for a selected bonus.

o (20) Changes to the datagrids for Employees and BonusInfo should be possible, to update to the database.

o (30) There should be a “Compute Payroll” that computes total of all employee pay, where each employee is paid:
EmpPay= Pay +( BonusItemAmount*JobBonus);

Ø EXTRA CREDIT: (5) If SQL Server is done, via importing the Access version or whatever.

Ø EXTRA CREDIT: (5) If programmatic “<” previous and “>” next button implementations are done for both datagrids.