1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57
| Private Sub Form_Load()
Dim SQL As String
Set cn = New ADODB.Connection
'Création des recordset
Set rsFourn = New ADODB.Recordset
Set rsCat = New ADODB.Recordset
Set rsSousCat1 = New ADODB.Recordset
Set rsSousCat2 = New ADODB.Recordset
Set rsSousCat3 = New ADODB.Recordset
'Création des liens
Set BndCat = New BindingCollection
'ouverture de la BD
cn.Provider = "MSDataShape"
cn.Open "Data Provider = Microsoft.Jet.OLEDB.4.0;" & " Data Source = C:\Developpez.com\Essais Réponses\Stocks\Stocks1.mdb"
SQL = " SHAPE {SELECT * FROM `CATEGORIE`} AS Command1 APPEND " _
& "(( SHAPE {SELECT * FROM `SOUSCATEGORIE1`} AS Command2 APPEND " _
& "(( SHAPE {SELECT * FROM `SOUSCATEGORIE2`} AS Command3 APPEND " _
& "(( SHAPE {SELECT * FROM `SOUSCATEGORIE3`} AS Command4 APPEND " _
& "({SELECT * FROM `FOURNITURE`} AS Command5 " _
& "RELATE 'ID_SousCategorie3' TO 'ID_SousCategorie3') AS Command5) AS Command4 " _
& "RELATE 'ID_SousCategorie2' TO 'ID_SousCategorie2') AS Command4) AS Command3 " _
& "RELATE 'ID_SousCategorie1' TO 'ID_SousCategorie1') AS Command3) AS Command2 " _
& "RELATE 'ID_Categorie' TO 'ID_Categorie') AS Command2"
rsCat.Open SQL, cn, adOpenDynamic, adLockOptimistic, adCmdText
rsCat.MoveFirst
MsgBox rsCat.RecordCount
Set rsSousCat1 = rsCat!Command2.Value
rsSousCat1.MoveFirst
MsgBox rsSousCat1.RecordCount
Set rsSousCat2 = rsSousCat1!Command3.Value
rsSousCat2.MoveFirst
MsgBox rsSousCat2.RecordCount
Set rsSousCat3 = rsSousCat2!Command4.Value
rsSousCat3.MoveFirst
MsgBox rsSousCat3.RecordCount
Set rsFourn = rsSousCat3!Command5.Value
rsSousCat1.MoveFirst
MsgBox rsFourn.RecordCount
Set BndCat.DataSource = rsCat
With BndCat
.Add Text1(0), "Text", "Denomination" ', , "Dénomination"
.Add Text1(5), "Text", "Quantite" ', , "Quantitée"
.Add Text1(6), "Text", "Prix" ', , "Prix"
.Add Text1(7), "Text", "Professionel", , "Professionel"
.Add Text1(8), "Text", "Remarque_Fourniture", , "Remarque"
End With
End Sub |
Partager