Rowset Viewer Example

This example describes how to connect to a provider, execute a command, and use IOpenRowset.

To connect to a provider

  1. Start ROWSETVIEWER.EXE.

  2. From the DataSource menu, choose Full Connect.

  3. Select MSDASQL as the provider and type OLE_DB_NWind_Jet for the DataSource parameter.

  4. Click Connect.

To execute a command

  1. In the top pane of the MDI child window, type the following query:

    SELECT * FROM CUSTOMERS
    

    2. 

  2. 
Click the ! button on the toolbar or choose ICommand::Execute from the Command menu.
    

    3. 




To use IOpenRowset

    

  1. 
In the top pane of the MDI child window, type CUSTOMERS.

    2. 

  2. 
Make sure that the SQL button is up and click the ! button, or choose IOpenRowset from the Session menu.
    3.