HOWTO: Accessing The Recordset DTC's Underlying ADO Recordset

ID: Q193231

The information in this article applies to:

SUMMARY

The underlying ActiveX Data Objects (ADO) Recordset created when a Recordset Design-time control (DTC) is included on an Active Server Page (ASP) can be accessed from ASP script using the getRecordSource() method of the Recordset Design-Time Control.


MORE INFORMATION

The getRecordSource() method of the Recordset DTC returns a copy of the ADO Recordset that is the source of the Recordset DTC. The following example sets an object to be the source ADO Recordset of a Recordset DTC and creates an HTML table of the field names and values.

  1. Open a project in Visual InterDev 6.0 and add a Data Connection (if one does not already exist).


  2. Add an Active Server Page to the project.


  3. Insert a Recordset DTC in the Active Server Page after the <BODY> tag.


  4. Right-click the Recordset DTC and select Properties.


  5. Set the Name to "Recordset1," the Source of Data to "Database object," and the database object to "Tables." Set the Object Name to a table of your choice.


  6. To access the Recordset generated by the Recordset DTC from ASP, insert the following VBScript code after the Recordset DTC: 
    
      <%
      '
      'Where Recordset1 is the name of your Recordset DTC
      '
      Dim tempRS
      Set tempRS = Recordset1.getRecordSource()

      Response.Write "<table border=1 cellpadding=4>"
      Response.Write "<tr>"

      For I = 0 To tempRS.Fields.Count - 1
         Response.Write "<td><b>" & tempRS(I).Name & "</b></td>"
      Next

      Response.Write "</tr>"

      Do While Not tempRS.EOF
        Response.Write "<tr>"

        For I = 0 To tempRS.Fields.Count - 1
          Response.Write "<td>" & tempRS(I) & "</td>"
        Next

        Response.Write "</tr>"

        tempRS.MoveNext
      Loop

      Response.Write "</table>"

      Set tempRS = Nothing
     %>


This is just one example of the capability available. Once you have the ADO Recordset object, all of the ADO Recordset methods and properties are available.

Additional query words: 


Keywords          : kbADO kbCtrl kbVisID600 kbGrpASP 
Version           : WINDOWS:6.0
Platform          : WINDOWS 
Issue type        : kbhowto

Last Reviewed: May 27, 1999