Working with Database Tables

For this project you will use the following database schema, which has two tables. 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 • Save and execute the file named Ch09Ex1.exe. Set the drive designator as necessary. For the solution... click for more

Order of magnitude

See attached

Create the control instances on the form as shown in the attachment

Create a new solution named Reservation.sln. • Create the control instances on the form as shown in the attachment. Note that the form contains multiple group boxes, DateTime Picker controls, and a NumericUpDown control. The cost of a hotel room is based on the following rules: • The base rate for the room depends on the room type. Standard = 84.50, Deluxe = 104.50, and Suite = 154.50. • If the number of guests is greater than 2, a $10.00 charge is imposed on each additional guest per night. • An additional rollaway bed costs $5.00 per night. • Declare constants as necessary to store the various rates. • Using the rules described in the previous list, write t... click for more

Payroll

• 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 Pavroll.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 YourName_Unit3.sln, setting the drive de... click for more

Programming in Visual Basic

I need to find a way to code this problem. Every time I click the "add to my cart" button, I need to add "1" to the Quantity ordered box. If I click it 5 times, there should be 5 in the Quantity Ordered. Also, the total cost needs to be 65.00 * the Quantity ordered and displayed in the Total Cost label. Can you help??? I have submitted a sample form.