Find Jobs
Hire Freelancers

DatabaseTable

$20-25 USD

Cerrado
Publicado hace alrededor de 20 años

$20-25 USD

Pagado a la entrega
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. • 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. ## 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) Exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Windows XP Visual Basic
ID del proyecto: 3087401

Información sobre el proyecto

8 propuestas
Proyecto remoto
Activo hace 20 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
8 freelancers are bidding on average $18 USD for this job
Avatar del usuario
See private message.
$17 USD en 4 días
5,0 (554 comentarios)
6,7
6,7
Avatar del usuario
See private message.
$21,25 USD en 4 días
5,0 (241 comentarios)
6,5
6,5
Avatar del usuario
See private message.
$21,25 USD en 4 días
5,0 (111 comentarios)
5,7
5,7
Avatar del usuario
See private message.
$21,25 USD en 4 días
5,0 (70 comentarios)
4,7
4,7
Avatar del usuario
See private message.
$12,75 USD en 4 días
5,0 (12 comentarios)
3,8
3,8
Avatar del usuario
See private message.
$21,25 USD en 4 días
4,9 (27 comentarios)
3,3
3,3
Avatar del usuario
See private message.
$17 USD en 4 días
4,9 (4 comentarios)
2,4
2,4
Avatar del usuario
See private message.
$8,50 USD en 4 días
4,9 (11 comentarios)
2,2
2,2
Avatar del usuario
See private message.
$17 USD en 4 días
3,9 (4 comentarios)
2,1
2,1

Sobre este cliente

Bandera de UNITED STATES
United States
5,0
4
Miembro desde dic 10, 2003

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.