Advertisement
Guest User

Untitled

a guest
Mar 1st, 2017
223
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. public void login(){
  2. var sql_login = "SELECT username,password FROM my_users WHERE username = @login_username AND password = @login_password;";
  3. SqliteCommand createCommand = new SqliteCommand (sql_login, dbCon);
  4. using (var cmd = dbCon.CreateCommand()) {
  5. cmd.CommandText = sql_login;
  6. cmd.Parameters.AddWithValue("@login_username",login_username.text);
  7. cmd.Parameters.AddWithValue("@login_password",login_password.text);
  8. cmd.ExecuteNonQuery();
  9.  
  10. SqliteDataReader dr = createCommand.ExecuteReader();
  11. int count = 0;
  12.  
  13. while(dr.Read()){
  14. count++;
  15. }
  16.  
  17. if(count == 1){
  18. Application.LoadLevel("Succes");
  19. }
  20.  
  21. if(count > 1){
  22. print("Duplicate");
  23. }
  24.  
  25. if(count < 1){
  26. print("Not Found");
  27. }
  28.  
  29. }
  30. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement