Reading, Writing, and Deleting Records from a Database

  • Status Closed
  • Budget $30 - $50 USD
  • Total Bids 4

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 [url removed, login to view] 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??, [url removed, login to view], 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 $[url removed, login to view]

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 [url removed, login to view]

Get free quotes for a project like this

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online