Simple School VB Project 2

**Previous two bids were cancelled because I received assistance from a friend after submitting.

This time that help is unavailable, and I will be accepting and paying for (PayPal) the lowest bids that can meet deliverables in the quickest timeframe. Thanks!


In this exercise, you will create a solution that works with two tables having a master/detail relationship. The first table contains employee records and the second table contains payroll transaction records for each employee.** The Figure shows the completed form for the solution.

(see platform for schemas - wouldn't fit)

## Deliverables

**Table 1 -- Schema for the tblEmployees table

Column Name - Data Type**

fldEmployeeID - Integer

fldName - String

fldAddress - String

fldCity - String

fldState - String

fldZipCode - String

**Table 2 -- Schema for table named tblPayroll

Column Name - Data Type

**fldEmployeeID - Integer

fldPayrollID - Integer

fldPayDate - Date

fldWithholding - Single

fldNetPay - Single

• Save and execute the file named [[url removed, login to view]][1]. Set the drive designator as necessary. For the solution to run, the database named [[url removed, login to view]][2] must exist 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 [url removed, login to view], 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 transaction, total gross pay, total withholding, and total net pay for the currently selected employee. Display the results in Label control instances at the bottom at the form. Format the output as currency. Right-justify the output in the Label control instances.

• Create an Exit button for the solution. In the Click event handler for the button, display a message box to get confirmation from the user before exiting the solution.

• Create an Update button that will allow the user to save any changes made to the DataGrid back to the database. Write the necessary code for the button. Allow the user to add, change, and delete records.

## Platform


Beceriler: .NET, Mühendislik, MySQL, PHP, Yazılım Mimarisi, Yazılım Test Etme, Visual Basic

Daha fazlasını gör: sure payroll, schema update, project handler, populate xml from database, list of designer names, designer names list, currency table list, payroll number, task number 1 project, sln-, simple payroll, school database, populate data in tables using xml, payroll so, Payroll project, old school, object designer, new school, write payroll, simple database visual basic

İşveren Hakkında:
( 3 değerlendirme ) United States

Proje NO: #3173508



See private message.

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(19 Değerlendirme)

Bu iş için 5 freelancer ortalamada $14 teklif veriyor


See private message.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(554 Değerlendirme)

See private message.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(215 Değerlendirme)

See private message.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(84 Değerlendirme)

See private message.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(75 Değerlendirme)

See private message.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)