Reading, Writing, and Deleting Records from a Database ------------------------------------------------------ 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??, 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.
This program has to be done in VisualBasic.net. To complete this project you will need to use some folder that i will provide later when i choose the coder. In other words, this program needs some folder that i have for the completition of it.
Visula [url removed, login to view]