Project Description

Connect database with Visitor information form: See Repo: VisitorInformation

Business Overview​​​​​​​

You work as a Junior Programmer at a software development company called Caterpiller Limited. Your company produces customized software solutions for other businesses throughout New Zealand.

They are using a desktop application to be used as a visitor registration system at reception desks of companies.

You have been tasked to update the customer data in the company database by creating connection between SSMS (SQL Server Management Studio)​​​​​​​ database and their existing visitor application.​​​​​​​

Below are the key points / pieces of code to complete the project:

SR09: Create a Connection string and provide all required information:

SR10: Create a connection between visitor application and SSMS database

SR11: Insert data into Visitor registration form and see the data has been added into “Visitor” table

SR13: Be able to edit an item from the list box using buttons for Edit, Save and Delete

SR14: Show functionality of Delete button: