Using the Results from the Recordset Object

  • 项目

Note

Indexing Service is no longer supported as of Windows XP and is unavailable for use as of Windows 8. Instead, use Windows Search for client side search and Microsoft Search Server Express for server side search.

 

The resulting RS Recordset object for the query, whether created with the Query Helper API or directly with the ActiveX Data Objects (ADO) API, provides the information in the list view of the results on the Main form. This code segment uses the MoveNext method of the RS Recordset object to read through the results and provide the selected properties to the list view control.

...
    Do Until RS.EOF
        Set mItem = ListView1.ListItems.Add()
        mItem.Text = RS("Filename")
        mItem.SubItems(1) = RS("Path")
        mItem.SubItems(2) = RS("Size")
        mItem.SubItems(3) = RS("Write")

        RS.MoveNext
    Loop
...