June 6, 2002
The objective of this session is to introduce Visual Studio developers to the basics of using ADO in Microsoft Visual Studio 6.0 and ASP applications to access SQL Server data as XML by executing SQLML queries. You will learn about the underlying architecture of using ADO to execute SQLXML queries. Code walkthroughs will be presented to illustrate how to execute different types of SQLXML queries (FOR XML AUTO, Templates, Updategrams, XPath queries against annotated mapping schemas, and applying an XSLT transformation to the result generated when you execute a SQLXML query) using ADO.
The code samples presented in the slides of this presentation will be written using Visual Basic 6.0. The presentation will not cover the basics of XML (and its related standards XSLT, Path, DOM, and the concept of XML parsers and XSD schemas) and SQLXML. Knowledge of these topics and familiarity with Visual Basic 6.0 and ASP development will be assumed.