Advertisement
Guest User

Untitled

a guest
Jul 21st, 2017
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.09 KB | None | 0 0
  1. private void button3_Click(object sender, EventArgs e)
  2. {
  3. // conn.Close(); conn.Open();
  4. //BeginInvoke(new check_delegat(check_data));
  5. //MessageBox.Show(_id);
  6. /*MySqlCommand command = new MySqlCommand(sql, conn);
  7. MySqlDataReader reader = command.ExecuteReader();
  8. while (reader.Read())
  9. {
  10. _id = reader["id_client"].ToString();
  11. }
  12. MessageBox.Show(_id);
  13. reader.Close();
  14. conn.Close();*/
  15.  
  16. //conn.Close(); conn.Open();
  17. using (MySqlConnection conn1 = new MySqlConnection(connStr))
  18. {
  19. conn1.Close();
  20. conn1.Open();
  21. string sql2 = "INSERT INTO `client_msg` VALUES (NULL, @id_client, @msg)";
  22. MySqlCommand command = new MySqlCommand(sql2, conn1);
  23. command.Parameters.AddWithValue("@id_client", "1");
  24. command.Parameters.AddWithValue("@msg", textBox5.Text);
  25. command.ExecuteNonQuery();
  26. conn1.Close();
  27. }
  28. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement