public void DoSomething(int param)
        {
            using (SqlConnection conn = new SqlConnection(ConnectionString))
            {
                conn.Open();

                using (SqlCommand cmd = new SqlCommand("COMANDO SQL o STORED PROCEDURE", conn))
                {
                    //questo solo se è stored procedure: cmd.CommandType = CommandType.StoredProcedure;

                    cmd.Parameters.AddWithValue("@param", param);
                    cmd.ExecuteNonQuery();
                }
            }
        }