Advertisement
Guest User

Untitled

a guest
Nov 14th, 2016
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. private void insertData()
  2. {
  3. string conStr = "server=127.0.0.1;user=user;" +
  4. "database=newBase;password=12345";
  5.  
  6. using (MySqlConnection con = new MySqlConnection(conStr))
  7. {
  8. try
  9. {
  10. string a = File.ReadAllText(@"title.txt", Encoding.Default);
  11. string b = File.ReadAllText(@"text_out.txt", Encoding.Default);
  12.  
  13.  
  14. string sql = "INSERT INTO items (Name, Cost) VALUES (@a, @b)";
  15. MySqlCommand cmd = new MySqlCommand(sql, con);
  16. cmd.Parameters.AddWithValue("@a", a);
  17. cmd.Parameters.AddWithValue("@b", b);
  18. con.Open();
  19. cmd.ExecuteNonQuery();
  20.  
  21.  
  22. }
  23.  
  24. catch (Exception ex)
  25. {
  26. MessageBox.Show(ex.Message);
  27. }
  28. }
  29. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement