remplir combobox a partir d'une bd

Bonjour, comment puis je remplir un combobox sous winform c# :

Code:

---

1 2 3 4 5 6 7 8 9 10

private void remplirListAO(string id) { string query = "SELECT NumAO FROM Appelsdoffre WHERE Guid = '" + id + "'";   SqlDataAdapter da = new SqlDataAdapter(query, connection); DataTable dt = new DataTable(); da.Fill(dt); cmbAO.DataSource = dt; cmbAO.DataBind(); }

---

solution :

Code:

---

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

private void remplirListAO() { string Query = "SELECT NumAO FROM Appelsdoffre ";   System.Data.SqlClient.SqlDataReader Reader; SqlCommand cmd = new SqlCommand(Query, connection);   connection.Open(); Reader = cmd.ExecuteReader(); cmbAO.Items.Clear(); while (Reader.Read()) { cmbAO.Items.Add(Convert.ToString(Reader.GetValue(0))); } Reader.Close(); cmbAO.SelectedIndex = 0; }

---