Reading, Writing, and Deleting Records from a Database

CLOSED
Bids
4
Avg Bid (USD)
$24
Project Budget (USD)
$30 - $50

Project Description:
Design and develop a windows application similar to the Today&'s Sales Check application provided. Use the solution to the Today&'s Sales Check application as a starting point for developing a new version of the application that uses information from a database, rather than information entered by the user.

Make the following modifications to the Today&'s Sales Check application so the application reads from a database to populate the ListView control on the formTodaysSalesCheck form. Add code to the formTodaysSalesCheck_Load event procedure and general area of the form code to read data from the TodaysSalesCheck.mdb Microsoft Access database supplied. The table name to read is TodaysSales. The field names are ItemDescription, TotalSales, and OnSale. The data types of the fields are String, Decimal, and Boolean.

Modify the code in the formAddItemForm to insert a record into the table using an SQL INSERT statement such as:

INSERT INTO TodaysSales (ItemDescription, TotalSales, OnSale)
VALUES (“Mulch??, 354.54, True)

Use structured exception handling where appropriate. Add code to the 1st TodaysSales_KeyDown event procedure to delete the record from the database as well as the ListView control. Remove the Clear Today&'s Sales List button from the form and remove the button&'s event procedures.

Bonus of $30.00
I will provide the extra application needed for the program to be done faster.


## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.


2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive 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

Visual Basic.NET

Skills required:
Database Administration, Engineering, MySQL, PHP, Software Architecture, Software Testing, SQL
Hire sandibiris
Project posted by:
sandibiris United States
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.