Advertisement
Guest User

Untitled

a guest
Feb 25th, 2019
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  1. public MainWindow()
  2. {
  3. InitializeComponent();
  4. string connStr = "server=localhost;user=root;database=carsdb;password=0000;";
  5. MySqlConnection conn = new MySqlConnection(connStr);
  6. conn.Open();
  7.  
  8. string sql = "SELECT id, mark, model, price FROM cars";
  9. MySqlCommand command = new MySqlCommand(sql, conn);
  10.  
  11. MySqlDataReader reader = command.ExecuteReader();
  12. while (reader.Read())
  13. {
  14. lstCars.Items.Add(reader[0].ToString() + " " + reader[1].ToString() + " " + reader[2].ToString() + " " + reader[3].ToString());
  15. }
  16.  
  17. conn.Close();
  18. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement