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 GetMD5HashForSt ring(string value)
{
if (value == null)
throw new ArgumentNullExc eption("The 'value' parameter cannot be null.");

ASCIIEncoding ae = new ASCIIEncoding() ;
byte[] stringAsBytes = ae.GetBytes(val ue);
byte[] hash = new MD5CryptoServic eProvider().Com puteHash(string AsBytes);

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

return sb.ToString().T oUpper();
}

"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.