SQL XML Utility in C#

This is a C# version of the SQL XML exploration utility from Appendix C of SQL Server 2000 XML Distilled.  The original was written by me in Visual Basic 6.0 and published in Appendix C to the book.  It used the XML extensions to the SQL Server OLEDB provider via ADO.  The original version is part of the publisher's download for the book.  This version is delivered as source code for the .Net Framework 1.1.  It should work with .Net Framework 1.0 but has not been tested that way.

This version has the same functionality as the original but uses the .NET SQL Server XML Managed Classes to process the queries, templates, and XSL transforms.  Of course, that makes it much simpler than the original. 

Before you try and run the source code, be sure that you have:

• Installed the SQLXML SP1 and all of it's prerequisites.
• Access to a SQL Server 2000 instance. Like all instances of SQL Server, yours should be upgraded to Service Pack 3a.
• The .Net Framework 1.1 and Visual Studio 2003

Use the download button in the upper right corner of this page to download the code. 

Additional information about two of the functions that are used in the demo can be found in the Tips and Tricks:

• Creating a COM object from its ProgID
• Opening an IE windows and navigating it to a URL