1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| Dim clients As List(Of client) = New List(Of client) ' défini la liste des clients et la cré
Sub chargeListeClient()
Using cn As New OleDbConnection("PROVIDER=Microsoft.ACE.OLEDB.12.0;Data Source=d:\data\personnes\personnes.accdb"), _
cmd As New OleDbCommand("select idclient, client_ste from client", cn)
Try
cn.Open()
Using reader As OleDbDataReader = cmd.ExecuteReader()
If reader.HasRows Then
Do While reader.Read()
clients.Add(New client(reader.GetInt32(0), reader.GetString(1))) ' insére un nouveau client à la liste des clients (id et nom)
Loop
Else
MessageBox.Show("aucun client.")
End If
reader.Close()
End Using
Catch ex As Exception
MsgBox(ex.ToString)
End Try
End Using
End Sub |