Welcome to the Lounge

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Configuration;

namespace InformationTechnologyInventoryStock
{
    public partial class Workstations : Form
    {
        private int n;

        public Workstations()
        {
            InitializeComponent();
        }

        private void Workstations_Load(object sender, EventArgs e)

        {
       
        }
        SqlConnection con = new SqlConnection(@"Data Source=SH-JASONK\DEV;Initial Catalog=StockInventory;Integrated Security=True");
        private void button1_Click(object sender, EventArgs e)
        {
            con.Open();
            SqlCommand cmd = new SqlCommand("INSERT INTO Workstations (Emp_Name, Emp_Surname, Department, Company, Hostname, Wkst_Status, Make, Model, SerialNumber, ProductNumber, PurchaseDate, ExpiryDate, Memory, Processor, HDD, OS, MSOffice) VALUES (@Emp_Name, @Emp_Surname, @Department, @Company, @Hostname, @Wkst_Status, @Make, @Model, @SerialNumber, @ProductNumber, @PurchaseDate, @ExpiryDate, @Memory, @Processor, @HDD, @OS, @MSOffice)");
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
          

            cmd.Parameters.AddWithValue("@Emp_Name", SqlDbType.VarChar);
            cmd.Parameters.AddWithValue("@Emp_Surname", SqlDbType.VarChar);
            cmd.Parameters.AddWithValue("@Department", SqlDbType.VarChar);
            cmd.Parameters.AddWithValue("@Company", SqlDbType.VarChar);
            cmd.Parameters.AddWithValue("@Hostname", SqlDbType.NVarChar);
            cmd.Parameters.AddWithValue("@Wkst_Status", SqlDbType.VarChar);
            cmd.Parameters.AddWithValue("@Make", SqlDbType.VarChar);
            cmd.Parameters.AddWithValue("@Model", SqlDbType.NVarChar);
            cmd.Parameters.AddWithValue("@SerialNumber", SqlDbType.NVarChar);
            cmd.Parameters.AddWithValue("@ProductNumber", SqlDbType.NVarChar);
            cmd.Parameters.AddWithValue("@PurchaseDate", dateTimePicker1.Value.Date);
            cmd.Parameters.AddWithValue("@ExpiryDate", dateTimePicker2.Value.Date);
            cmd.Parameters.AddWithValue("@Memory", SqlDbType.NVarChar);
            cmd.Parameters.AddWithValue("@Processor", SqlDbType.NVarChar);
            cmd.Parameters.AddWithValue("@HDD", SqlDbType.NVarChar);
            cmd.Parameters.AddWithValue("@OS", SqlDbType.NVarChar);
            cmd.Parameters.AddWithValue("@MSOffice", SqlDbType.NVarChar);

            cmd.Connection = con;
            DataTable dt = new DataTable();
          
            sda.Fill(dt);
            cmd.ExecuteNonQuery();
            con.Close();
            MessageBox.Show("INSERTED SUCCESSFULLY");

        }



    }
        }