Guest User

Untitled

a guest
Oct 22nd, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. private void Load_BTN_Click(object sender, EventArgs e)
  2. {
  3.  
  4.  
  5. try
  6. {
  7.  
  8. string selectQuery = "Select * from Fuel_Attendend";
  9. cmd = new SqlCommand(selectQuery, connection);
  10. try
  11. {
  12. connection.Open();
  13. dr = cmd.ExecuteReader();
  14. while (dr.Read())
  15. {
  16. this.chart1.Series["Date"].Points.AddXY(dr.GetString(3), dr.GetInt32(6));
  17.  
  18. }
  19.  
  20. }
  21. catch(Exception ex)
  22. {
  23. MessageBox.Show(ex.Message);
  24. }
  25.  
  26. connection.Close();
  27. }
  28. catch (Exception ex)
  29. {
  30. MessageBox.Show(ex.Message);
  31. }
  32. }
Add Comment
Please, Sign In to add comment