Question: Open the JM Sales Solution (JM Sales Solution.sln) file contained in the VB2015Chap14JM Sales Solution folder. The application is connected to the AnnualSales database, which

Open the JM Sales Solution (JM Sales Solution.sln) file contained in the VB2015\Chap14\JM Sales Solution folder. The application is connected to the AnnualSales database, which contains a table named tblSales. Each record in the table has two numeric fields: YearNum (the primary key) and Sales. The btnAdd_Click procedure should allow the user to add records to the database. The btnDelete_Click procedure should allow the user to delete records (by year number) from the database. Use SQL to code the procedures. Test the application appropriately. Be sure to try adding a record whose year number matches an existing year number.

Step by Step Solution

3.52 Rating (152 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Microsoft Visual Studio Solution File Format Version 1200 Visual Studio 14 VisualStudioVersion 140225120 MinimumVisualStudioVersion 100402191 ProjectF184B08FC81C45F6A57F5ABD9991F28F JM Sales Project J... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming with Microsoft Visual Basic 2015 Questions!