I have this one from harbor freight. Been fine for over a year, use it all the time.  Locks on to the valve stem which is nice and has a nice big gauge on it.  Plus it's 90% cheaper than the others in this thread.   
http://www.harborfreight.com/pistol-grip-tire-inflator-with-gauge-68270.html