How can I insert data into a table using c#?

Question

Hello everyone!

 

I've got a simple table 'Table' in a simple database 'Database1' with 2 rows (Id,Chemin) and I'm trying to insert data into my table but the opening of the connection to the database doesn't work (con.Open()). Can someone tell me why and help me please ? The code is below :

SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=Database1;Integrated Security=True");
SqlCommand cmd = new SqlCommand("sp_insert", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Chemin", textBox1.Text); //cmd.Parameters.AddWithValue("@email", textBox2.Text);
con.Open();
int i = cmd.ExecuteNonQuery();
con.Close();