C#

using (SqlConnection conn = new SqlConnection( sqlConnection1.ConnectionString))


                using (SqlCommand cmd = new SqlCommand("dbo.insertIntoCustomerTable"))
                {
                    cmd.CommandType = CommandType.StoredProcedure;

                    
                    cmd.Parameters.Add(new SqlParameter("@companyName", ""));
                    cmd.Parameters.Add(new SqlParameter("@unitSection", ""));
                    cmd.Parameters.Add(new SqlParameter("@streetAddress", ""));
                    cmd.Parameters.Add(new SqlParameter("@city", ""));
                    cmd.Parameters.Add(new SqlParameter("@zip", ""));
                    cmd.Parameters.Add(new SqlParameter("@buissnessContactName", ""));
                    cmd.Parameters.Add(new SqlParameter("@buissnessContactPhone", ""));
                    cmd.Parameters.Add(new SqlParameter("@buissnessContactEmail", ""));
                    cmd.Parameters.Add(new SqlParameter("@buisnessContactEmailBad",false));
                    cmd.Parameters.Add(new SqlParameter("@groupEmail", false));
                    cmd.Parameters.Add(new SqlParameter("@isbAnaylist", ""));
                    cmd.Parameters.Add(new SqlParameter("@requestorCode", ""));
                    cmd.Parameters.Add(new SqlParameter("@toCustomer", false));
                    cmd.Parameters.Add(new SqlParameter("@toCustomerDate", ""));
                    cmd.Parameters.Add(new SqlParameter("@fromCustomer", false));
                    cmd.Parameters.Add(new SqlParameter("@fromCustomerDate", "")); 
                    cmd.Parameters.Add(new SqlParameter("@toPST", false));
                    cmd.Parameters.Add(new SqlParameter("@toPSTDate", ""));
                    cmd.Parameters.Add(new SqlParameter("@iacUpdated", false));
                    cmd.Parameters.Add(new SqlParameter("@sft", false));
                    cmd.Parameters.Add(new SqlParameter("@vpn", false));
                    cmd.Parameters.Add(new SqlParameter("@epnVendor", ""));
                    cmd.Parameters.Add(new SqlParameter("@epnPackage", false));
                    cmd.Parameters.Add(new SqlParameter("@dlInquiry", false));
                    cmd.Parameters.Add(new SqlParameter("@abstractUpdate",false));
                    cmd.Parameters.Add(new SqlParameter("@juryExtract", false));
                    cmd.Parameters.Add(new SqlParameter("@bulkExtract", false));

                    conn.Open();

                    cmd.Connection = conn;

                    int rows = cmd.ExecuteNonQuery();

                    MessageBox.Show("" + rows);

                    cmd.Connection.Close();

                }