Recover encrypted field from a database

[aecordoba]

Hi there! I want to save an encrypted password in a database in order to authenticate the users of my application (on C# 2.0). So, I encrypted the password provided by the user, as following: UnicodeEncoding unicodeEncoding = new UnicodeEncoding(); byte[] passwordArray = unicodeEncoding.GetBytes(password); SHA1Managed sha1Managed = new SHA1Managed(); byte[] encryptedPassword = sha1Managed.ComputeHash(passwordArray); Then, I saved the password in 'varbinary(160)' field in a table of database (SQL Server 2005): DataSet.Users.AddUsersRow(userName, encryptedPassword); UsersTableAdapter userTableAdapter = new UsersTableAdapter(); userTableAdapter.Update(DataSet.Users); How can I recover this encrypted password in order to compare it with a new encrypted password provided by the user? This code: byte[] passwordArray = row["Password"]; doesn't compile because "it can't convert object to byte[]". Thank you, in advance.

-- Adrián Córdoba

[Colin Angus Mackay]

Try casting it first:

byte[] passwordArray = (byte[])row["Password"];

---

Upcoming events: * Glasgow: Introduction to AJAX (2nd May), SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services... Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton My website

[aecordoba]

Thank you very, very much!

-- Adrián Córdoba