First of all, I'm going to stop you and allow you to realise how your loneliness and frustration towards women is affecting the way you see women themselves. You're beginning to objectify them and you feel as if, by the amount of effort you feel like you're putting in to get their attention or affection, you're entitled to their attention.
This way of thinking is dangerous. I completely understand that you're frustrated and angry at this probably occurring repetitively, but as you become angrier, the less women will want you. It is not attractive, and you will have a harder time finding a woman for yourself.
I would advise you to try to remain patient, and perhaps try to look for love - or sex, whatever you're looking for - elsewhere. Clubs and such aren't the only way you can find these things. You just need to find a girl who likes you for you, and whom you like in return.
Please don't give up if you're unlucky in clubs or whatever. The women there are either out to have fun or are looking for a very specific type of guy that you are not. Some people are petty, and you must realise that some people are petty - not all women.
You just need to hold on and eventually your time will come when you find the right girl. It's a clichéd answer and I know you hate it, but it's true. Love is the sort of thing that will come unexpectedly. Please believe me.