1, 直接在SQL SERVER下对加密字段加密
insert into usertable
(username, upassword) values ('new',hashbytes('MD5','123456'));
insert into usertable
(username, upassword) values ('new', pwdencrypt('123456'));
2, 通过程序源代码对加密字段加密后, 再写入数据库
在网上找到了一个最简单的MD5方法, 试了试, 执行通过. 先放这做个记录:
private string MD5(string pass)
{
try
{
byte[] hashvalue = (new MD5CryptoServiceProvider()).ComputeHash(Encoding.UTF8.GetBytes(pass));
return BitConverter.ToString(hashvalue);
}
catch
{
return String.Empty;
}
}