Empty database table

Vote count:

0

I want to insert values in "Navn" row and "Varenr" row in the DB table, when I'm clicking on a button. I have following code:

 private void button2_Click(object sender, EventArgs e)
    {

        using (SqlConnection cn = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\Produkt.mdf;Integrated Security=True"))
        {
            try
            { 
            SqlCommand cm = new SqlCommand();
            cm.Connection = cn;
            string col1 = textBox2.Text;
            string col2 = textBox3.Text;

            //generate sql statement
            cm.CommandText = "INSERT INTO ProduktTable (Navn,Varenr) VALUES (@col1,@col2)";
            //add some SqlParameters
            SqlParameter sp_add_col1 = new SqlParameter();
            sp_add_col1.ParameterName = "@col1";
            //data type in sqlserver
            sp_add_col1.SqlDbType = SqlDbType.NVarChar;
            //if your data type is not number,this property must set
            //sp_add_col1.Size = 20;
            sp_add_col1.Value = textBox2.Text;
            //add parameter into collections
            cm.Parameters.Add(sp_add_col1);
            //in your insert into statement, there are how many parameter, you must write the number of parameter
            SqlParameter sp_add_col2 = new SqlParameter();
            sp_add_col2.ParameterName = "@col2";
            //data type in sqlserver
            sp_add_col2.SqlDbType = SqlDbType.NVarChar;
            //if your data type is not number,this property must set
            //sp_add_col2.Size = 20;
            sp_add_col2.Value = textBox2.Text;
            //add parameter into collections
            cm.Parameters.Add(sp_add_col2);

            //open the DB to execute sql
            cn.Open();
            cm.ExecuteNonQuery();
            cn.Close();
                }
            catch (Exception ex)
            {
                MessageBox.Show("Error\n" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }                
        }
    }

But unfortunately, my data table is still empty:

I have set a breakpoint on the ExecuteNonQuery function, and it is triggered, when pressing on the button:

asked 55 secs ago

user2292615

56