Guest User

Untitled

a guest
Jun 5th, 2018
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. MySqlConnection DBConnection = new MySqlConnection("server=*;port=3306;username=*;Password=*;Database=*;sslmode=none");
  2. DBConnection.Open();
  3. MySqlCommand CMD = new MySqlCommand("select * from Movies order by ID desc limit 3", DBConnection);
  4. MySqlDataReader Reader = CMD.ExecuteReader();
  5. while(Reader.Read())
  6. {
  7. ID1 = Reader.GetInt32(0);
  8. ID2 = ID1 - 1;
  9. ID3 = ID2 - 1;
  10. ID4 = ID3 - 1;
  11.  
  12. Reader.Close();
  13.  
  14. for (int i = 1; i <= 3; i++)
  15. {
  16. MySqlCommand Post1CMD = new MySqlCommand("select * from Movies where ID =" + i, DBConnection);
  17. MySqlDataReader PostReader = Post1CMD.ExecuteReader();
  18. if (PostReader.Read())
  19. {
  20. MessageBox.Show(PostReader.GetString(1));
  21. }
  22. }
  23. }
Add Comment
Please, Sign In to add comment