Well, I don't really like Schwarzkopf Hair Spray, but nonetheless, that's the only hair spray I have tried so far.
It does hold your hair, but at the same time, it makes your hair extremely dry after that - once you have washed it away. It also melts when you sweat, thus, totally not something you want to use in tropical weather! And it does take a while to dry, so you have to hold your hair in position, spray, and wait until it dries up.
I also didn't quite like the smell as it was very strong! And it isn't a very pleasant smell either
The good thing about it is, it's has a rather slim can, so it easily fits into the bag. It also gives you the shine when you have it on, but not when you have it off after that!