protected void btnLogin_Click(object sender, EventArgs e) { string username = txtUsername.Text; string password = txtPassword.Text; SqlOperation op = new SqlOperation(); MySqlDataReader dr = op.login(username, password); if (dr.HasRows) { //Successful login dr.Read(); Session.Add("userid", dr.GetValue(0)); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Log in successful.');window.location.href ='index.aspx';</script>"); } else { //Unsuccessful login ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Log in failed. Please try again.');</script>"); } }