Best numerical methods textbooks?

Anyone have recommendations on the best numerical methods textbooks? Ideally, it would have enough details (theory and algorithms) to implement unconstrained/contrained nonlinear optimization, ode/pde solvers, numerical integration routines, etc