protected void Button1_Click(object sender, EventArgs e)
{
Class1 cs = new Class1();
SqlConnection con = new SqlConnection("Data Source=FENG-PC;Initial Catalog= files;Trusted_Connection=True");
con.Open();
string select = "select username,password,Email,usrid,categorise,catego,belogntoteach from userinfo where username= '******'AND password='******'";
SqlCommand seletive = new SqlCommand(select, con);
SqlDataReader reader = seletive.ExecuteReader();
if (reader.Read())
{
Session["userid"] = reader[3];
Session["name"] = reader[0];
cs.writelog(reader[0].ToString() + " has login on " + DateTime.Now.ToString());
if (reader[4].ToString() == "2")
{
Response.Redirect("studentover.aspx");
}
else if (reader[4].ToString() == "1")
{
Session["categ"] = reader[5].ToString();
Session["TAid"] = reader[6];
Session["userid"] = reader[3];
Response.Redirect("teacher.aspx");
}
else if (reader[4].ToString() == "3")
{
if(DropDownList1.SelectedValue=="2")
Response.Redirect("studentover.aspx");
else
Response.Redirect("assistant.aspx");
}
else if (reader[4].ToString() == "0")
{
Response.Redirect("admin.aspx");
}
}
else
{
Response.Write("it is no user");
}
cs.writelog(reader[3].ToString() + "has login on" + DateTime.Now.ToString());
con.Close();
}