dr['AID']=112100011TextBox1.Text=1121000177
dr['apassword']=245fghTextBox2.Text=123456
dr['AID']=1121000177TextBox1.Text=1121000177
dr['apassword']= 123456TextBox2.Text=123456
用户名或密码不正确,请重新输入!
这是运行时页面打印出来的,其中第二个记录就是与数据库中数据完全一样,为什么还是现实用户名或密码不正确呢????
这是编码部分:
Session["AID"] = Server.HtmlEncode(TextBox1.Text.Trim());
SqlConnection sqlconn = new SqlConnection(connectstring);
string cmdText = "select AID,apassword from dbo.管理员";
SqlCommand command = new SqlCommand(cmdText, sqlconn);
try
{
//打开连接
sqlconn.Open();
//执行查询
SqlDataReader dr = command.ExecuteReader();
while (dr.Read())
{
Response.Write("dr['AID']=" + dr["AID"].ToString() + "TextBox1.Text=" + TextBox1.Text + "
");
Response.Write("dr['apassword']=" + dr["apassword"].ToString() + "TextBox2.Text=" + TextBox2.Text + "
");
if ((dr["AID"].ToString() == TextBox1.Text) && (dr["apassword"].ToString() == TextBox2.Text))
{
Response.Redirect("后台管理界面.aspx");
}
}
Response.Write("用户名或密码不正确,请重新输入!");
dr.Close();
}
catch (SqlException sqlex)
{
//显示错误信息
Response.Write(sqlex.Message + "<br>");
}
finally
{
//关闭数据连接
sqlconn.Close();
}