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.

posted by Eugenia Loli-Queru on Wed 20th Feb 2002 18:45 UTC (New Mobile Computing)
A lot of people have trouble understanding what .NET really is and what its goals are. Mostly because Microsoft has done a good job of confusing everybody using terms that are not self-explanatory or with terms that mean more that one thing.

posted by Eugenia Loli-Queru on Mon 19th Nov 2001 19:44 UTC (New Mobile Computing)
Today, OSNews features an interview with Zac Woodall, software design Engineer at Office Data and Developer Services at Microsoft Corporation . Zac, who is also a frequent OSNews reader, talks about the new Office, .NET, WindowsXP, NTFS and how it compares to BFS filesystem, the GPL & open source movement and much more.

Job vacancy: Senior Development Officer (PublicTechnology.net)
(Ref: SDO) The successful candidate will join our Business & Information Systems Development team and work in an open plan office with the rest of the team. The post-holder will assist the development team in all aspects of its work.

FREE Subscription

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

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

_______________________________________

Recommended XML Books