Create a console application. You should get the following information from the user
o First name
o lastname
o email
o password
o confirm
o address1
o city
o stateprovince
o zipcode
o dayphone
Step 2 :
Run the create-customer.sql available in this folder to create the customer table to store this information.
Step 3
Run the Create-sp_addCustomer.sql to create the stored procedure sp_addCustomer that adds a new customer's details to the customers table.
Step 4.Give an option to add a customer,on selecting the option run the sp_addCustomer passing the required parameters
4a.Start with creating SqlConnection, passing the appropriate connection string.
4b.Create a new SqlCommand object, passing the name of the stored procedure to be called as a string.
4c. Set the command type of the command object to Stored Procedure
4d.Using the parameters collection of the command object add a parameter for each parameter you need to pass from the sign up form.
4e. Now fill in the @customer_id output parameter.Create a SqlParameter and initialize it with string "@customer_id" and a type of SqlDbType.Int.Set the direction of the parameter to ParameterDirection.Output. Finally add this parameter to the command.
4f.Now open the connection and execute the stored procedure by calling the cmd object's ExecuteNonQuery () method.Dont forget to handle exceptions and close connection safely
4g.Check the output parameter customer_id and display the following: You are successfully signed. Please note your customer id is <..> for future reference.