Novick Software
SQL Server Consulting Design Programming Tuning

  andy novick is a sql server mvp

 

 

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:

 


RSS as HTML

Personal Blog

 
New Tips:

Use dsinit to set the SQL Server instance for Windows Azure dev storage

Upcoming
Presentations:

SQL PASS
Nov 7, '12
Biggest
Loser: DB
Edition


Full Schedule