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