About DevGuru.com

DevGuru.com is a developer's resource featuring comprehensive quick references for current technologies, free online tutorials, and "ask DevGuru," the place to get your most difficult programming questions answered from leading experts around the world. Check them out at http://www.devguru.com
SQL Server 2000, XML and XSL: The Ultimate Combination

All the hype that once surrounded XML is finally starting to die down, and developers are really beginning to harness the power and flexibility of the language.

A Beginner’s Guide to Using Active Server Pages
· 1

The objective of this tutorial is to introduce Active Server Pages (ASP) to individuals who are responsible for developing, building, managing or maintaining a Web site. We will define ASP, differentiate between ASP and conventional HTML, demonstrate how to create and convert Web application pages to ASP, and demonstrate how to use ASP for further Web applications. This will involve using JavaScript or Visual Basic Script (VBScript) to write applications that can be run on an ASP Web server.

Using Disconnected Recordsets

Anyone who works with databases will probably at some stage have occasion to work with a particular Recordset over a period of time. However, it would not be practical or desirable to maintain an open connection to the database throughout as this would tie up connection resources. Instead, the user can take advantage of the server’s ability to create disconnected Recordsets.

Creating the XML Document

This tutorial is divided into two parts. We will explain how to create an XML document and how to assign data types to the values in the XML document. All of the examples in this tutorial are designed to be viewed with either Internet Explorer 5.0 or 5.5.

A Beginner’s Guide to Data Access Using ADO and ASP

The primary aim of this tutorial is to demonstrate how to execute an SQL command within an Active Server Page and display the results in an HTML table.