Question

C# 连接access数据库的，asp.net登陆按钮程序有管理员和一般用户权限之分；求后台详细代码。

Answer 1

具有md5加密的登录代码 

protected void Button1_Click(object sender, EventArgs e)
    {
        MD5CryptoServiceProvider md5Hasher = new MD5CryptoServiceProvider();
        UTF8Encoding encoder = new UTF8Encoding();
        byte[] hashedBytes = md5Hasher.ComputeHash(encoder.GetBytes(TextBox3.Text));
        dbhelper dbhelper=new dbhelper ();
        if (Session["验证码"].ToString() == TextBox5.Text)
        {
            string connstring = dbhelper.getConnstring();
            OleDbConnection conn = dbhelper.getConn(connstring);
            conn.Open();
            string commstring = "select count(*) from 会员表 where 会员昵称=@会员昵称 and 密码=@密码";
            OleDbCommand comm = dbhelper.getComm(commstring, conn);
            comm.Parameters.AddWithValue("会员昵称", TextBox1.Text);
            comm.Parameters.AddWithValue("密码", hashedBytes);
            int num = (int)comm.ExecuteScalar();
            if (num == 1)
            {
                Session["会员昵称"] = TextBox1.Text;
                Response.Redirect("home.aspx");
            }
            else {
                Label1.Text = "用户名或密码错误！";
            }
            conn.Close();
        }
        else
        {
            Label1.Text = "验证码错误！";
        }
           
    }