• Download and run the executable file named Ch09Ex1.exe. For the solution to run, you will need to download the database named [login to view URL] that you will find in the Drop Box, which you must saved in the same folder as the executable file. The input form contains a list box, and a DataGrid control instance. Select employee names in the ListBox control instance. The corresponding payroll information appears in the DataGrid. As you select different employees, the payroll totals are recalculated for the selected employee. • Start VB .NET and create a new solution named [login to view URL], setting the drive designator as necessary. • Configure the form so that it appears on the center of the desktop when the solution is run. Also, configure the form so that the user cannot resize it. • Using the OleDbConnection and OleDbDataAdapter controls, create a connection to the database. Use two Old DbDataAdapter control instances to get the data from the two respective tables. Generate one DataSet based on the two DataAdapters. Write the necessary statements in the frmMain_Load event handler to populate the DataSet. • Using the XML Designer, define a DataRelation to link the field named fldEmployeelD between the two tables. • Create an instance of the ListBox control. Set the necessary properties so that the ListBox control will display the field fldName in the table named tblEmplovees. • Create an instance of the DataGrid control on the form. Configure the DataGrid control instance so that it displays records from the table named tblPavroll. Use the DataRelation object to accomplish this task. Make sure that the DataGrid control instance displays the payroll records for the currently selected employee. • Format the DataGrid so that the column header names are the same as the ones shown in the Figure. Make the background color of the selected row light blue. Also, make sure that the rows have an alternating color. • Write the necessary code to calculate the number of tra
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
## Platform
VB.NET 2002 Windows 2000