How to bind ADO recordset
Create an ASP page that returns the data in a CSV format :
open your connection
open your recordset
do while not rs.eof
str = str & rs("whatever") & "," & rs("whatever") & vbCrlf
close your recordset
close your connection
The " vbCrlf " is important because it simulates a character break which it needs. You can pop the above in a function and return the string.
Then use the XML Request example (called Yahoo something if I'm not mistaken) and then modify the URL to point to the ASP file. You're also able to pass through paramters etc to filter the search somehow?
Go to town with this... it's strange how people find it difficult to integrate asp/recordsets into the grid. I found it much too easy. :D
IE allows binding data to HTML tags in the client. The data source can be, for instance, an XML data island or an ADO recordset (not ADO.NET). The Activewidgets package comes with an example that shows how to use it with a XML data island but does not say anything about ADO recordsets.
Binding a data source object to a table is supported by IE through the use of 2 attributes: DATASRC and DATAFLD.
This topic is archived.
Back to support forum
Version 2Looking for AW 2.6 ?
The old site is here.