修改数据库二进制数据

 

 

public static byte[] EncryptPassword(string password)
    {
        byte[] bytes = new UnicodeEncoding().GetBytes(password);
        SHA1 sha = new SHA1CryptoServiceProvider();
        return sha.ComputeHash(bytes);
    }
  protected void btnLogin_Click(object sender, EventArgs e)
    {
      
        byte[] encPassword = EncryptPassword("111");//转换为二进制流
        string sql = "update Accounts_Users set password =@password";
        SqlParameter[] parameters = { new SqlParameter("@password", SqlDbType.Binary) };
        parameters[0].Value = encPassword;
       
        int flag = Convert.ToInt32(DbHelperSQL.ExecuteSql(sql,parameters));
}