Dynamic web pages using ASP, XML, and SQL

You can create dynamic web pages using asp, xml and sql. If you are creating dynamic pages using asp and xml then you can use the Server.CreateObject method to create an xml object and load the xml document using the Load method available for that xml object.

It is standard to use the Server.MapPath to get the physical path of the xml file to use in the Load method. Then you have to navigate the elements in the xml document and display them in the web page.

For using sql in an asp you will be using ADO connection to the database in which the data is available. The next step is to open the database connection and create a RecordSet.

Then open the recordset and extract data from it and display it in the asp page using Response.Write. Finally close the record set and the database connection.

Lots of examples are available the internet on how to use xml with asp and sql with asp.

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. _______________________________________