Payroll Information ()

Payroll Information

Job Summary:

Job Type:	Project
Budget:	$ 20-100
Required Skills:
Attached Files:	(None)

Status:	Waiting feedback from elukens

Buyer Summary:

Username:

Feedback Score:

5 reviews

Award Reliability:

6 posted 6 paid

Location:

NY, US

Member Since:

April 6, 2006

Invited Users:

There are no invited users

Description

For this project the following database schema, which has two tables will be used.

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
fldGrossPay Single
fldWithholding Single
fldNetPay Single

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.

• Save and execute the file named Ch09Ex1.exe. Set the drive designator as necessary. For the solution to run, the database Payroll.mdb, which can be downloaded in the following zip file named Payroll.zip must exist in the same folder as the executable file. (Download the zip and extract the database file to the folder) 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 Unit3.sln, 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 OleDbDataAdapter 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.

I have sln examples....I will send once Project is awarded

Reminder

You may not start working in this and any request before your bid is accepted. Users who violate this policy may have their accounts permanently suspended.

Bids Received (0)

Shortlist (0)

Declined Bids (0)

Average bid amount:

$0.00

Average delivery time:

0 Day(s)

| | |

Order by:

Remember that contacting the other party outside the site (by email, phone, etc.) on all business jobs (before the request is awarded) is a violation of our terms of use. We supervise all site activity for such infringements and can immediately expel transgressors on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thank you for your help.

Get the Free Step-by-Step Guide on How to Use GetACoder

The act of outsourcing jobs has become easy in the past few years thanks to GetACoder. However, our team aims at making the whole process even easier. So, it has now come the time to provide you with a step-by-step guidance on how to use this service and succeed in the outsourcing world totally for FREE.

It doesn't matter if you are a more experienced user or a novice; using GetACoder will become even simpler with the help of this E-book. There are two major sections: a Buyers section and a Coders section.

Buyers will learn:

How to outsource safely
How to pick the best freelancers
How to manage time and money

Coders will learn:

How to get the best jobs
How to secure their payments
How to build a long-lasting relationship with buyers

...and MUCH MORE

Clear examples and pictures illustrating key situations, great tips and real testimonies of some of our best users... all in this Outsourcing Guide. So don't loose the outstanding opportunity to download GetACoder FREE E-book.

The Outsourcing Revolution: Why It Makes Sense and How to Do It Right

What is GetACoder?

GetACoder is a leading Global Services Marketplace doing business in more than 200 countries. Our unique system accelerates your time to market and provides your business with key competitive advantages. When you use GetACoder you are stretching your budget and saving as much as 60% over traditional outsourcing. GetACoder is changing business, now it's no longer about what you own or build but which resources and talent you can access. With GetACoder you reduce expenses, increase efficiencies, aggressively grow your business, and create a sustainable competitive advantage. GetACoder makes outsourcing to any part of the world an easy task! With GetACoder it's simple to outsource any business request, gain access to global talent and manage jobs online.

One of the main advantages of GetACoder is the low labor cost. The typically rates are about seven times lower than the ones in the US or Europe. Posting a request at GetACoder allows the right professional or company to find you and to bid for your work. We are building a reputation for exceeding our customers' expectations and for becoming an extremely cost effective way to outsource work. Use GetACoder when you want to save money, increase efficiency or accelerate the development of your request. With GetACoder you focus on growing your business and let others do the tedious work. Post your request on GetACoder for free. Find out why people outsource jobs with us day after day.

Thousands of Satisfied Customers - Submit/View Quotes

-	For years I have struggled to find quality coders to bring my ideas to life and here I found coders with talent. - Droog
-	I feel lucky for working at GetACoder and I am a real fan of this site. - shamithctg
-	It's a really authentic and reliable site for freelancing. - ALAMGIR259