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ùand you don't have to write a lot of code to do it. You can also use it with ActiveX^« Data Objects to create robust applications that give you a high degree of programming control over the behavior of your application's data.

This tutorial takes the "minimal code" approach, and the Developer's Guide provides more information for using the RDS.DataControl with ActiveX Data Objects and other advanced features. 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.