My advice?
If you've tried everything you feel you can to get a girlfriend, and nothing has come of it; stop trying.
Make the most of the things in your life that you do have. Come to some sort of acceptance with your 'alone' status. Start finding ways to enjoy yourself that don't hinge on a romantic partner.
Believe me, being okay with being single is a pretty wonderful place to be.
Any relationship that happens after that, is just sort of a life bonus. But you'll not be pathetic and desperate if it doesn't work out because you'll know you can be okay