Advertisement
Guest User

Untitled

a guest
Sep 4th, 2016
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. void fill_listbox()
  2. {
  3. string constring = "datasource=localhost;port=3306;username=root;password=xdmemes123";
  4. string Query = "select * from life.players ;";
  5. MySqlConnection conDataBase = new MySqlConnection(constring);
  6. MySqlCommand cmdDataBase = new MySqlCommand(Query, conDataBase);
  7. MySqlDataReader myReader;
  8. try
  9. {
  10. conDataBase.Open();
  11. myReader = cmdDataBase.ExecuteReader();
  12.  
  13. while (myReader.Read())
  14. {
  15. string sName = myReader.GetString("name");
  16. namelistbox.Items.Add(sName);
  17. }
  18. }catch (Exception ex)
  19. {
  20. MessageBox.Show("Something went wrong. Error copied to clipboard.");
  21. Clipboard.SetText(ex.Message);
  22. }
  23. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement