How do i ask him if he wants to spend the night with me ?

I would just ask him. I highly doubt he'll say no, because he'll think he might be able to get some.