Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public Client idSelect(string hash, string username)
- {
- Client clientObj = new Client();
- //Open connection
- if (this.OpenConnection() == true)
- {
- try
- {
- //Create Command
- MySqlCommand cmd = new MySqlCommand(null, connection);
- //Creation de la requête SQL
- cmd.CommandText = "SELECT * FROM users " + "WHERE us_name=@parUSR " + "AND us_passwd=@parPWD";
- //Creation des paramètres SQL
- MySqlParameter parUSR = new MySqlParameter("@parUSR", MySqlDbType.VarChar, 50);
- MySqlParameter parPWD = new MySqlParameter("@parPWD", MySqlDbType.VarChar, 256);
- //Assignation des valeurs
- cmd.Parameters.AddWithValue("@parUSR", username);
- cmd.Parameters.AddWithValue("@parPWD", hash);
- //Préparation et exécution de la requête
- cmd.Prepare();
- cmd.ExecuteNonQuery();
- //Create a data reader and Execute the command
- MySqlDataReader dataReader = cmd.ExecuteReader();
- //Read the data and store them in the list
- while (dataReader.Read())
- {
- clientObj.Us_id = (dataReader["us_id"]+ "").ToString();
- clientObj.Us_name = (dataReader["us_name"] + "").ToString();
- clientObj.Us_passwd = (dataReader["us_passwd"] + "").ToString();
- }
- //close Data Reader
- dataReader.Close();
- //close Connection
- this.CloseConnection();
- }
- catch(Exception e)
- {
- }
- }
- return clientObj;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement