Dim itmX As Object
Dim adoConnection As ADODB.Connection
Dim ContactRst As ADODB.Recordset
Dim sConnectionString As String
Set adoConnection = New ADODB.Connection
Set ContactRst = New ADODB.RecordsetsConnectionString " Provider Microsoft.jet.OLEDB.3.51;" & " Data Source = C:\Program Files\Microsoft Visual Studio\vb98\Biblio.mdb"
adoConnection.Open sConnectionString
ContactRst.Open "Publishers", adoConnection
'Dim Y As Integer
'For Y = 0 To ContactRst.RecordCount - 1
While Not ContactRst.EOF
Set itmX = ListView1.ListItems. _
Add(, , CStr(ContactRst!Name)) ' Author.
' Si le champ AuthorID n'est pas nul, affecte sa
' valeur au sous-élément 1.
If Not IsNull(ContactRst!Address) Then
itmX.SubItems(1) = CStr(ContactRst!Address)
End If
If Not IsNull(ContactRst!City) Then
itmX.SubItems(2) = CStr(ContactRst!City)
End If
' Si le champ "Year of Birth" n'est pas nul,
' affecte sa valeur au sous-élément 2.
If Not IsNull(ContactRst!State) Then
itmX.SubItems(3) = ContactRst!State
End If
ContactRst.MoveNext ' Passe à l'enregistrement suivant.
Wend