Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public MainWindow()
- {
- InitializeComponent();
- string connStr = "server=localhost;user=root;database=carsdb;password=0000;";
- MySqlConnection conn = new MySqlConnection(connStr);
- conn.Open();
- string sql = "SELECT id, mark, model, price FROM cars";
- MySqlCommand command = new MySqlCommand(sql, conn);
- MySqlDataReader reader = command.ExecuteReader();
- while (reader.Read())
- {
- lstCars.Items.Add(reader[0].ToString() + " " + reader[1].ToString() + " " + reader[2].ToString() + " " + reader[3].ToString());
- }
- conn.Close();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement