Complete the Chapter 13 Cheap Loans project from the Visual Basic textbook. Add

Complete the Chapter 13 Cheap Loans project from the Visual Basic textbook. Add the following modifications:Create a SQL Server database and a table that contains the following:Loan number (primary key), customer name, amount of loan, annual interest rate and term of loan in yearsStart a Visual Studio web site project (ASP.NET)Add the proper controls (labels, text boxes, etc.) to allow the user to enter the loan dataUse RequiredFieldValidators for each text boxUse the Financial.Pmt method to calculate the monthly payment. Test your results by using an online loan payment calculator.When the user clicks submit, insert the data into the table.Add another button that when clicked, displays another page.This page should have a GridView that displays the data from the table. No need for Update or Delete options.Include a link back to the default page.Refer to the Aquarium example for help.Be creative, and feel free to explore this technology as much as you want.

You may also like