Building a Simple Remote Data Service Application

   

You can use the RDS.DataControl object to create a simple Active Server Pages file that accesses a live database.

This tutorial takes the "minimal code" approach, though the Developer's Guide provides more information for using the RDS.DataControl. In this tutorial, you will connect to a Microsoft® Access database, display a result set in a data-bound grid, and add the ability to navigate through the displayed Recordset. The following procedure outlines the steps you'll take to create this simple application:

  1. Identify the database.

  2. Insert the grid and the RDS.DataControl object.

  3. Add HTML controls.

  4. Add code to send a query to the database.

  5. Add code to submit changes to the database.

  6. Add code to move through the displayed Recordset.

  7. See the code in action.

If you want to see a finished version of this sample application, you can go to http://<webservername>/MSADC/Samples/ADCTest.asp, where <webservername> is the name of your Web server.