Advertisement
Guest User

Untitled

a guest
May 3rd, 2016
45
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.28 KB | None | 0 0
  1. {
  2. SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["RegistreringConnectionString"].ConnectionString);
  3. connection.Open();
  4. string kollaAnvandare = "select count(*) from Registreing where Anvandarnamn= '" + AnvandarNamn.Text + "'";
  5. SqlCommand command = new SqlCommand(kollaAnvandare, connection);
  6. int temp = Convert.ToInt32(command.ExecuteScalar().ToString());
  7. connection.Close();
  8. if (temp == 1)
  9. {
  10. connection.Open();
  11. string kontrolleraLosen = "select Losenord from Registreing where Anvandarnamn= '" + AnvandarNamn.Text + "'";
  12. SqlCommand losenOrdCommand = new SqlCommand(kontrolleraLosen, connection);
  13. string losenord = losenOrdCommand.ExecuteScalar().ToString().Replace(" ", "");
  14. if (losenord == losenOrd.Text)
  15. {
  16. Session["New"] = AnvandarNamn.Text;
  17. Response.Write("Lösenord är korrekt!");
  18. Response.Redirect("spelSida.aspx");
  19. }
  20. else
  21. {
  22. Response.Write("Lösenord är felaktigt!");
  23. }
  24. }
  25.  
  26. else
  27. {
  28. Response.Write("Användarnamn är felaktigt!");
  29. }
  30.  
  31. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement