writhe the program in Visual Studio using . net programming.

A local business wants you to write a program to store their customers information in a data base. The program should gather the following customer information as input on an Add Customer form:

• First and Last name
• Address
• City
• State
• Zip Code
• Loyalty Card number. (This is can be any numeric 6 digit number.)

Outputs: Output will be written to TCustomers table in dbSQL1 using the provided script.

The program should allow the business to Add, Delete and Update customer information in the DB. Add an Exit button that will close the program or any forms opened from main form. Add a Clear button that will clear out any input on the Add Customer form. Make sure you have comments in your program explaining what you are doing. Also make sure you test your program, per your design, prior to submitting.

Extra Credit: Create a table in the DB for states. Create the FK between the customers table and the states table. Insert data into the states table and use that data to populate a combo box for State on your form(s).

Object Explorer 4x Customers(1) (1).s...LBA6555\kalau (51)) + X Connect - * *7th o & LAPTOP-ELBA6S55\MSSQL SERVER3 (SC # Databases Options # Security # Server Objects USE dbSQL1; Get out of the master database #Replication SET NOCOUNT ON; Report only errors # PolyBase Drop Tables # Always On High Availability # Management + Integration Services Catalogs IF OBJECT_ID 'TCustomers') IS NOT NULL DROP TABLE TCustomers SQL Server Agent # XEvent Profiler Step #1.1: Create Tables CREATE TABLE TCustomers ( intCustomer ID INTEGER NOT NULL strFirstName VARCHAR (255 NOT NULL , strLastName VARCHAR(255 NOT NULL , strAddress VARCHAR(255 NOT NULL strcity VARCHAR (255 NOT NULL , strSate VARCHAR (255 NOT NULL , strzip VARCHAR(255 NOT NULL , str LoyaltyCard VARCHAR(255) NOT NULL ,CONSTRAI TCustomers_PK PRIMARY KEY ( intCustomerID) Object Explorer 4x Customers(1) (1).s...LBA6555\kalau (51)) + X Connect - * *7th o & LAPTOP-ELBA6S55\MSSQL SERVER3 (SC # Databases Options # Security # Server Objects USE dbSQL1; Get out of the master database #Replication SET NOCOUNT ON; Report only errors # PolyBase Drop Tables # Always On High Availability # Management + Integration Services Catalogs IF OBJECT_ID 'TCustomers') IS NOT NULL DROP TABLE TCustomers SQL Server Agent # XEvent Profiler Step #1.1: Create Tables CREATE TABLE TCustomers ( intCustomer ID INTEGER NOT NULL strFirstName VARCHAR (255 NOT NULL , strLastName VARCHAR(255 NOT NULL , strAddress VARCHAR(255 NOT NULL strcity VARCHAR (255 NOT NULL , strSate VARCHAR (255 NOT NULL , strzip VARCHAR(255 NOT NULL , str LoyaltyCard VARCHAR(255) NOT NULL ,CONSTRAI TCustomers_PK PRIMARY KEY ( intCustomerID)