Description This sample shows how you can generate XML data from an ADO recordset. We programmatically create an ADO recordset object on the web server in response to parameters that the user selects. The client portion of the application implements a simple user interface that collects the parameters required to create the ADO recordset object. More Details The client user interface code is contained in the sample1.htm file. It collects three parameters from the user: the computer that your SQL Server database resides on, the database to use, and the SQL query to execute against the database. A good choice would be to use the standard pubs standard database and the ubiquitous select * from titles query. There are two server-side Active Server Page (ASP) files that can be called from the client. The runQuery.asp file contains the VBScript version of the code and the runQueryJ.asp file contains the JavaScript version of the code. You can choose which page is called by changing the action attribute of the HTML
ADO, ASP and XML - 15 Nov 2001
0 comments
Hide comments