Advertisement
Guest User

Untitled

a guest
Jul 19th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.67 KB | None | 0 0
  1. private void calculateflyinghours()
  2. {
  3. string ConString = " datasource = localhost; port = 3306; username = root; password = 3306";
  4. string Querry = " Select sum(Flying_Hours)from aircraft." + Form1.a;
  5.  
  6. MySqlConnection ConDatabase = new MySqlConnection(ConString);
  7. MySqlCommand cmdDataBase = new MySqlCommand(Querry, ConDatabase);
  8.  
  9.  
  10. MySqlDataReader myReader;
  11.  
  12.  
  13. ConDatabase.Open();
  14.  
  15. myReader = cmdDataBase.ExecuteReader();
  16.  
  17.  
  18. while ((myReader.Read()))
  19. {
  20.  
  21. sum.Text = Convert.ToString(double.Parse(myReader.GetString(0)));
  22. progressBar1.Increment(1);
  23. }
  24. myReader.Close();
  25. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement