Reading, Writing, and Deleting Records from a Database

Closed

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.

Necessary applications will be given for this code.

Program is needed for 4:30p.m today 4/13/04

## 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]

Skills: Database Administration, Engineering, MySQL, PHP, Software Architecture, Software Testing, SQL

See more: writing types, writing today, writing procedures, writing in names, writing a statement, writing a procedure, writing applications, writing and reading, web listview, u. s. a. today, reading writing, new hire procedures, new hire check list, name writing, microsoft access web database, list the uses of web design package, hire sales writing, functional writing, code writing software, code for insert data in sql in web design, clear writing, clear a string in c, check writing software, basic writing, area of a point

Project ID: #3170780

Awarded to:

moderncoder

See private message.

$51 USD in 2 days
(326 Reviews)
7.1

3 freelancers are bidding on average $43 for this job

waynewareso

See private message.

$51 USD in 2 days
(75 Reviews)
5.2
complitech

See private message.

$25.5 USD in 2 days
(14 Reviews)
4.3