String md5pwd = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(pwd, "md5");
        try
        {
            con.Open();
            OleDbCommand com = new OleDbCommand("select * from Admin_Users where Admin_User_Name='" + user + "' and Admin_User_Pwd='" + md5pwd + "'", con);
            OleDbDataReader dr = com.ExecuteReader();
            if (dr.Read())
            {
                HttpCookie usersCookie = new HttpCookie("user", dr["Admin_User_Name"].ToString());
                Response.Cookies.Add(usersCookie);
                Response.Redirect("Default.aspx");
            }
            else
            {
                Response.Write("<script>alert('用户名或密码错误!');</script>");
            }
        }
        catch (Exception ex)
        {
            Response.Write("<script>alert('" + ex.Message + "');</script>");
        }
        finally
        {
            con.Close();
        }

解决方案 »

  1.   

    //登陆,成功记录cookie,否则提示失败
    String md5pwd = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(pwd, "md5"); 
            try 
            { 
                //操作数据库
                con.Open(); 
                OleDbCommand com = new OleDbCommand("select * from Admin_Users where Admin_User_Name='" + user + "' and Admin_User_Pwd='" + md5pwd + "'", con); 
                OleDbDataReader dr = com.ExecuteReader(); 
                if (dr.Read()) 
                { 
                    HttpCookie usersCookie = new HttpCookie("user", dr["Admin_User_Name"].ToString()); 
                    Response.Cookies.Add(usersCookie); 
                    Response.Redirect("Default.aspx"); 
                } 
                else 
                { 
                    Response.Write(" <script>alert('用户名或密码错误!'); </script>"); 
                } 
            } 
            catch (Exception ex) 
            { 
                Response.Write(" <script>alert('" + ex.Message + "'); </script>"); 
            } 
            finally 
            { 
                con.Close(); 
            }