SQL Insert procedure called from C#

[C# Programming]

End Google Ads 201810 - BS.net 01 --> Visual Studio 2005, using SQL Express, I have stored SQL procedure to insert a row into my database. The return code from ExecuteNonQuery is 1 indicating a row was added, but when I check my database, there is no new row. When I run the procedure from the IDE, it inserts a row.

When debugging I do get Method may only be called on a type for which Type.Is Generic is true.

Here is the code block

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();

}