Q: login screen

[JIM.H.]

Hello,
Can anyone give me a link (C#) that handle login screen while keeping
username and password encrypted in the SQL Server?
Thanks,
Jim.

[Craig]

You can store the password in md5 format in the database and when the
password is entered, you can convert it to md5 and compare to the md5
password in the database.

use this method to convert a string to md5:

public static string GetMD5HashForString(string value)
{
if (value == null)
throw new ArgumentNullException("The 'value' parameter cannot be null.");

ASCIIEncoding ae = new ASCIIEncoding();
byte[] stringAsBytes = ae.GetBytes(value);
byte[] hash = new MD5CryptoServiceProvider().ComputeHash(stringAsByt es);

// Convert the byte array to a printable string.
StringBuilder sb = new StringBuilder(32);
foreach (byte hex in hash)
sb.Append(hex.ToString("X2"));

return sb.ToString().ToUpper();
}

"JIM.H." wrote:

Hello,
Can anyone give me a link (C#) that handle login screen while keeping
username and password encrypted in the SQL Server?
Thanks,
Jim.