protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection sqlconn = Connection.GetConn();
sqlconn.Open();
string sqlcommandstr = "select * from log_in";
SqlCommand sqlcommand = new SqlCommand(sqlcommandstr,sqlconn);
SqlDataReader sqldatareader = sqlcommand.ExecuteReader();
string name = TextBox1.Text;
string password = TextBox2.Text;
int tag = 1;
while (sqldatareader.Read())
{
if (name.Equals(sqldatareader["user_name"].ToString().Trim()) && password.Equals(sqldatareader["password"].ToString().Trim()))
{
tag = 2;
Response.Redirect("student_1.aspx");
}
}
{
SqlConnection sqlconn = Connection.GetConn();
sqlconn.Open();
string sqlcommandstr = "select * from log_in";
SqlCommand sqlcommand = new SqlCommand(sqlcommandstr,sqlconn);
SqlDataReader sqldatareader = sqlcommand.ExecuteReader();
string name = TextBox1.Text;
string password = TextBox2.Text;
int tag = 1;
while (sqldatareader.Read())
{
// Response.Write(sqldatareader["user_name"]);
//去掉从数据库中读取一串字符串的两边的空格
//不然的老师匹配成功出错
if (name.Equals(sqldatareader["user_name"].ToString().Trim()) && password.Equals(sqldatareader["password"].ToString().Trim()))
{
tag = 2;
Response.Redirect("student_1.aspx");
}
}