Using the SQLXML Managed Classes

This section provides sample applications that demonstrate how to use the Microsoft SQLXML Managed Classes.

For information about accessing and modifying data in SQL Server 2005 within the Microsoft .NET Framework, and about using DiffGrams to update data in SQL Server tables, see Accessing SQLXML Functionality in the .NET Environment.

Note

You can also write Microsoft Visual Studio applications to bulk load XML documents by using XML Bulk Load. For more information, see Performing Bulk Load of XML Data (SQLXML 4.0). You must add a reference to the XML Bulk Load DLL (Xblkld4.dll) in your application. This is a COM DLL for which Visual Studio .NET automatically creates the wrapper library.

In This Section

• Executing SQL Queries (SQLXML Managed Classes)

• Executing SQL Queries by Using the ExecuteXMLReader Method

• Processing XML on the Client Side (SQLXML Managed Classes)

• Executing XPath Queries (SQLXML Managed Classes)

• Executing XPath Queries with Namespaces (SQLXML Managed Classes)

• Executing Template Files by Using the CommandText Property

• Executing Template Files by Using the CommandStream Property

• Applying an XSL Transformation (SQLXML Managed Classes)