Password Encryption / Hashing

Question

I have a login application in C# that I need to store ciphered values in the password column of a database. What is the best way to achieve this? Hash algorith? Obviously I need to compare the value from the database with the entered plain text on my login screen to see if they are the same before validating login. I just want to prevent users seeing plain text passwords that have access to view the database. cheers