首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 网站开发 > asp.net >

新手!页面登录失败

2012-03-31 
新手求助!页面登录失败!C# codeprotected void Page_Load(object sender, EventArgs e){if(!Page.IsPostBa

新手求助!页面登录失败!

C# code
    protected void Page_Load(object sender, EventArgs e)    {         if(!Page.IsPostBack)        {            sCap = Createcapstring(6); //验证码字符创建            capimg.Src = sCapimageurl + sCap;        }    }    protected void logbut_Click(object sender, EventArgs e)    {          if(Page.IsValid == true)          {              if(captxt.Text != sCap)              {                  string errortext = "验证码错误!";                  capref.Text = errortext;                  Response.Write("<script>alert('验证码错误!')</script>");                  sCap = Createcapstring(6);                  capimg.Src = sCapimageurl + sCap;              }              string adminid = "";                                      //string adminname = Server.HtmlEncode(username.Text.Trim());              //string adminpsd = Server.HtmlEncode(password.Text.Trim());              string adminname = username.Text.Trim();              string adminpsd = password.Text.Trim();              string str = "SELECT * FROM T_Admin WHERE F_UserName='" + adminname + "' AND F_Password='" + password + "';";              olecmd = new OleDbCommand(str, olecon);              try              {                  olecon.Open();                  OleDbDataReader oledr = olecmd.ExecuteReader(CommandBehavior.CloseConnection);                  if (oledr.Read())                  {                      adminid = oledr["AdminID"].ToString();                      Session["AdminID"] = adminid;                      Response.Redirect("~/Crmain.aspx");                         }                  else                  {                      Response.Write("<script>alert('用户名或密码有误!')</script>");                  }                   oledr.Close();                  oledr.Dispose();              }              catch (OleDbException oleex)              {                  throw oleex;              }              finally               {                  olecon.Close();              }            }    }

C# code
   if (oledr.Read())                  {                      adminid = oledr["AdminID"].ToString();                      Session["AdminID"] = adminid;                      Response.Redirect("~/Crmain.aspx");                         }
加了断点,if (oledr.Read())没有执行直接跳进else,sql语句应该没问题啊,都没报错,试了很多总是登录错误,望各位大大帮忙看看

[解决办法]
探讨

引用:

try
{
olecon.Open();
OleDbDataReader oledr = olecmd.ExecuteReader();
// OleDbDataReader oledr = olecmd.Execute……
取消了关闭部分,还是登陆不了

热点排行