Guest User

Untitled

a guest
Apr 5th, 2018
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.95 KB | None | 0 0
  1. private void doneButton_Click(object sender, EventArgs e) {
  2. string userName = userNameTextBox.Text,
  3. password = passwordTextBox.Text,
  4. question = questionMenu.Text,
  5. answer = answerTextBox.Text;
  6. int key = EncryptionClass.generateKey();
  7.  
  8. SqlConnection connection = SQLHelper.GetConnection();
  9. String sqlQuery = "INSERT INTO dbo.Account(UserName, UserPassword, UserKey) " +
  10. "VALUES ('" + userName + "', '" + EncryptionClass.encrypt(password, key) + "', " + key + ");";
  11.  
  12. Console.WriteLine("string " + sqlQuery);
  13. //INSERT INTO dbo.Account(UserName, UserPassword, UserKey) VALUES ('somename', 'Lysjehqcqhe01', 16);
  14. SQLHelper.ExecuteNonQuery(sqlQuery, connection);
  15. }
  16.  
  17. namespace Assign6 {
  18. class SQLHelper {
  19. public static SqlConnection GetConnection() {
  20. SqlConnection connection = new SqlConnection(@"Data Source=(LocalDB)MSSQLLocalDB;AttachDbFilename=|DataDirectory|MyData.mdf;Integrated Security=True");
  21.  
  22. connection.Open();
  23. return connection;
  24. }
  25.  
  26. public static void ExecuteNonQuery(string sqlQuery, SqlConnection connection) {
  27. using (SqlCommand command = new SqlCommand(sqlQuery, connection)) {
  28. try {
  29. command.ExecuteNonQuery();
  30. }
  31. finally {
  32. connection.Close();
  33. }
  34. }
  35. }
  36. }
  37. }
  38.  
  39. <?xml version="1.0" encoding="utf-8" ?>
  40. <configuration>
  41. <configSections>
  42. </configSections>
  43. <connectionStrings>
  44. <add name="Assign6.Properties.Settings.MyDataConnectionString"
  45. connectionString="Data Source=(LocalDB)MSSQLLocalDB;AttachDbFilename=|DataDirectory|MyData.mdf;Integrated Security=True"
  46. providerName="System.Data.SqlClient" />
  47. </connectionStrings>
  48. <startup>
  49. <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.6.1" />
  50. </startup>
  51. </configuration>
Add Comment
Please, Sign In to add comment