1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
Private Sub Form_Load()
Dim req As String
req = "SELECT * FROM comptes"
'-----connexion base de donnée ACCESS-----------
cn.CursorLocation = adUseServer
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\base\Gestion des Stagiaires.mdb"
'définition du type de recordset
rs.CursorLocation = adUseServer
rs.ActiveConnection = cn
rs.Properties("IrowsetIdentity") = True
'----execute requete
rs.Open req, cn, adOpenKeyset, adLockPessimistic
'-----Remplir le datagrid
Set DataGrid1.DataSource = rs
cn.Close
End Sub |