Advertisement
Guest User

Untitled

a guest
Mar 3rd, 2017
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.53 KB | None | 0 0
  1. protected void loginbutton_Click(object sender, EventArgs e)
  2. {
  3. string UsernameRegex = "[a-zA-Z]+";
  4. string PasswordRegex = "[a-zA-Z0-9]+";
  5.  
  6. if (!Regex.IsMatch(usernametextbox.Text, UsernameRegex))
  7. {
  8. string UsernameCheck = "valid";
  9. }
  10. else
  11. {
  12. string UsernameCheck = "invalid";
  13. }
  14.  
  15. if (!Regex.IsMatch(passwordtextbox.Text, PasswordRegex))
  16. {
  17. string PasswordCheck = "valid";
  18. }
  19. else
  20. {
  21. string PasswordCheck = "invalid";
  22. }
  23.  
  24.  
  25. if(UsernameCheck = "valid") //i will include password here after i solved the problem
  26. {
  27. //do something
  28. }
  29. SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
  30. conn.Open();
  31. string checkuser = "select count(*) from Users where Username = @username and Password = @password";
  32.  
  33. SqlCommand com = new SqlCommand(checkuser, conn);
  34. com.Parameters.Add("@username", SqlDbType.NVarChar).Value = usernametextbox.Text;
  35. com.Parameters.Add("@password", SqlDbType.NVarChar).Value = passwordtextbox.Text;
  36.  
  37. int temp = Convert.ToInt32(com.ExecuteScalar().ToString());
  38.  
  39. if (temp > 0)
  40. {
  41. Response.Redirect("Cars.aspx");
  42. }
  43. else
  44. {
  45. loginfaillabel.Text = "Your Username or Password doesn't match our records";
  46. }
  47. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement