Advertisement
Guest User

Untitled

a guest
Dec 6th, 2016
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.99 KB | None | 0 0
  1. public Client idSelect(string hash, string username)
  2. {
  3.  
  4. Client clientObj = new Client();
  5.  
  6. //Open connection
  7. if (this.OpenConnection() == true)
  8. {
  9. try
  10. {
  11.  
  12. //Create Command
  13. MySqlCommand cmd = new MySqlCommand(null, connection);
  14.  
  15. //Creation de la requête SQL
  16. cmd.CommandText = "SELECT * FROM users " + "WHERE us_name=@parUSR " + "AND us_passwd=@parPWD";
  17.  
  18. //Creation des paramètres SQL
  19. MySqlParameter parUSR = new MySqlParameter("@parUSR", MySqlDbType.VarChar, 50);
  20. MySqlParameter parPWD = new MySqlParameter("@parPWD", MySqlDbType.VarChar, 256);
  21.  
  22. //Assignation des valeurs
  23. cmd.Parameters.AddWithValue("@parUSR", username);
  24. cmd.Parameters.AddWithValue("@parPWD", hash);
  25.  
  26. //Préparation et exécution de la requête
  27. cmd.Prepare();
  28. cmd.ExecuteNonQuery();
  29.  
  30. //Create a data reader and Execute the command
  31. MySqlDataReader dataReader = cmd.ExecuteReader();
  32.  
  33. //Read the data and store them in the list
  34. while (dataReader.Read())
  35. {
  36. clientObj.Us_id = (dataReader["us_id"]+ "").ToString();
  37. clientObj.Us_name = (dataReader["us_name"] + "").ToString();
  38. clientObj.Us_passwd = (dataReader["us_passwd"] + "").ToString();
  39. }
  40.  
  41. //close Data Reader
  42. dataReader.Close();
  43.  
  44. //close Connection
  45. this.CloseConnection();
  46.  
  47. }
  48.  
  49. catch(Exception e)
  50. {
  51.  
  52. }
  53. }
  54.  
  55. return clientObj;
  56.  
  57. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement