Working with ASP, ADO, and XML


Creating dynamic pages to display data that is got from an external source can be done in asp easily. The data in the external file could be either in an xml file or in a database. If the data is in a database you have to follow certain steps to get it displayed.


_______________________________________________

You have to create an ADO connection to the database. The next step is to open the database connection and create a recordset object. Get the data you want in the recordset object using the sql query and then open the recordset and extract data from it. You can use Response.

Write to display the data in the web page and then close the recordset and the database connection.To display data from an XML file, create an xmldom object to load the xml file.

Load the xml file in the xmldom object and then navigate through the xmldom object to retrieve data from the xml object. The retrieved data can be stored in variables and you can use these variables to display data in the web page.





_______________________________________________

FREE Subscription

Subscribe to our mailing list and receive new articles
through email. Keep yourself updated with latest
developments in the industry.

Name:
Email:

Note : We never rent, trade, or sell my email lists to
anyone. We assure that your privacy is respected
and protected.

_______________________________________








 

 

FREE Subscription

Stay Current With the Latest Technology Developments Realted to XML. Signup for Our Newsletter and Receive New Articles Through Email.

Name:

Email:

Note : We never rent, trade, or sell our email lists to anyone. We assure that your privacy is respected and protected.

 

 

Add to My Yahoo!

Visit XML Training Material Guide Homepage

 

 

Copyright - © 2004 - 2017 - All Rights Reserved.