Guest User

Untitled

a guest
Jun 21st, 2018
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.97 KB | None | 0 0
  1. string connstr = "server=localhost; user=root; database=users_db; password=0000";
  2. MySqlConnection conn = new MySqlConnection(connstr);
  3. string sql_registrUser = "INSERT INTO `users_db`.`users` (`user_login`, `user_password`) VALUES ('" + login + "', '" + password + "');";
  4. MySqlCommand comm_registr = new MySqlCommand(sql_registrUser, conn);
  5.  
  6. MyCommand.ExecuteNonQuery();
  7.  
  8. string sql_registrUser = "INSERT INTO `users_db`.`users` (`user_login`, `user_password`) VALUES ('" + login + "', '" + password + "');";
  9. MySqlCommand comm_registr = new MySqlCommand(sql_registrUser, conn);
  10. comm_registr.ExecuteNonQuery();
  11.  
  12. private OleDbConnection GetConnection()
  13. {
  14. OleDbConnectionStringBuilder oleStringBuilder = new OleDbConnectionStringBuilder();
  15. oleStringBuilder.Provider = "Microsoft.ACE.OLEDB.12.0";
  16.  
  17. var currentDir = Path.GetDirectoryName(this.GetType().Assembly.Location);
  18. oleStringBuilder.DataSource = Path.Combine(currentDir, "wordsDb.accdb");
  19.  
  20. OleDbConnection connection = new OleDbConnection(oleStringBuilder.ConnectionString);
  21.  
  22. return connection;
  23. }
  24.  
  25. public int AddWord(Word word)
  26. {
  27. if (word == null) throw new ArgumentNullException(nameof(word));
  28. if (String.IsNullOrWhiteSpace(word.Eng)) throw new ArgumentException("Английское значение обязательное");
  29. if (String.IsNullOrWhiteSpace(word.Rus)) throw new ArgumentException("Русское значение обязательное");
  30.  
  31. int result = 0;
  32.  
  33. using (OleDbConnection connection = GetConnection())
  34. using (OleDbCommand command = connection.CreateCommand())
  35. {
  36. command.CommandText = "INSERT INTO Words (english, russian) VALUES (@eng, @rus)";
  37. command.Parameters.AddWithValue("eng", word.Eng);
  38. command.Parameters.AddWithValue("rus", word.Rus);
  39.  
  40. connection.Open();
  41. result = command.ExecuteNonQuery();
  42. }
  43.  
  44. return result;
  45. }
Add Comment
Please, Sign In to add comment