Advertisement
Guest User

Untitled

a guest
Jul 10th, 2017
58
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 button1_Click(object sender, EventArgs e)
  2. {
  3. //int isP = 0;
  4. string a = comboBox1.Text;
  5. string ConString = " datasource = localhost; port = 3306; username = root; password = 3306";
  6.  
  7. {
  8.  
  9.  
  10. {
  11. string sql = "SELECT count (*) FROM [initialentry] WHERE aircraft_number = @a";
  12. using (MySqlConnection cn = new MySqlConnection(ConString))
  13. {
  14. cn.Open();
  15. using (MySqlCommand cmd = new MySqlCommand(sql, cn))
  16. {
  17. cmd.Parameters.AddWithValue("@aircraft_number", a);
  18. MySqlDataReader reader = cmd.ExecuteReader();
  19.  
  20. if (reader.HasRows)
  21. {
  22. label1.Text = "Record exists";
  23.  
  24. }
  25. else
  26. {
  27. label1.Text = "Record does not exist";
  28. }
  29.  
  30.  
  31.  
  32.  
  33. }
  34. }
  35. }
  36. }
  37. }`
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement