Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

SAMPLE: How To Retrieve XML Data Using an XPath Query with ADO in Visual C++


View products that this article applies to.

This article was previously published under Q271782

↑ Back to the top


Summary

XPath.exe demonstrates how to extract an XML stream from a SQL Server 2000 database by using an XPath query and ADO in Visual C++.

↑ Back to the top


More information

The following file is available for download from the Microsoft Download Center:
Release Date: 10-04-2000

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591� How to Obtain Microsoft Support Files from Online Services
Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file. The XPath.exe file contains the following files:

Collapse this tableExpand this table
File nameSize
EULA.txt2 KB
AdoHeader.h1 KB
CustomerOrder.xml2 KB
ReadMe.txt1 KB
resource.h1 KB
StdAfx.cpp1 KB
StdAfx.h1 KB
XPath.cpp3 KB
XPath.dsp5 KB
XPath.dsw1 KB
XPath.h2 KB
XPath.rc5 KB
XPathDlg.cpp7 KB
XPathDlg.h2 KB
\Res\XPath.ico2 KB
\Res\XPath.rc22 KB

This sample demonstrates how to run an XPath query to output an XML stream. The sample shows how to configure an ADO Command object to run an XPath query by using the Command object's CommandText property. Alternatively, you can do this by using the CommandStream property and an input Stream as well.

Additionally, the sample provides a mapping schema file that contains mapping information between elements and attributes in the XPath query and the tables and columns contained in the back-end SQL Server 2000 relational database management system (RDBMS). The CustomerOrder.xml mapping schema file provided with this sample contains information about a SQL JOIN between the Customers and Orders tables and their columns in terms of the Customers and CustOrder elements and their attributes. All the tables are from the Northwind sample database in SQL Server 2000.

The sample does the following:
  1. Sets up a connection to a valid SQL Server 2000 database:

    Note uid <user name> must have the appropriate permissions to perform these operations on the database.
    _bstr_t m_Conn("PROVIDER=SQLOLEDB.1;Server=SQL2000Srv;Database=Northwind;uid=<user name>;pwd=<strong password>;");
    					
  2. Assigns the XPath globally unique identifier (GUID) to the ADO Command object's Dialect property:
    hr = cmd->Properties->Item[L"Mapping Schema"]- >put_Value(_variant_t(L"\\CustomerOrder.xml")); 
    					
  3. Sets the ADO Command object's Mapping Schema property to point to the mapping schema file CustomerOrder.xml:
    hr = cmd->Properties->Item[L"Mapping Schema"]->put_Value(_variant_t(L"C:\\MySchemaFilePath\\CustomerOrder.xml"));
    					
  4. Sets the ADO Command object's Output Stream property to an ADO Stream for retrieving the XML data:
    hr = cmd->Properties->Item[L"Output Stream"]->put_Value(_variant_t((IDispatch*) strm));
    					
  5. Sets the Command object's CommandText property to the XPath query:
    // Default XPATH Query is -
    // m_XPathIn = L"/Customers/CustOrder[@CustomerID=\"ALFKI\"]";
    hr = cmd->put_CommandText(_bstr_t(m_XPathIn ));
    					
  6. Runs the Command by using the adExecuteStream enumeration:
    hr = cmd->Execute(&vra,&vtEmpty,adExecuteStream);
    					

Steps to Run the Sample

  1. Unzip the XPath.exe file.
  2. Modify the connection string in XPathDlg.cpp to refer to a valid SQL Server 2000 database.
  3. Compile and then run the application.

↑ Back to the top


References

271780� SAMPLE: How To Retrieve XML Data using a SQL XML Query with ADO in Visual C++
271775� SAMPLE: How To Retrieve Relational Data Using OpenXML with ADO in Visual C++
272180� SAMPLE: How to Retrieve XML Data Using a Template File with ADO in Visual C++
SQL Server 2000 Books OnLine ADO 2.6 Documentation

↑ Back to the top


Keywords: kbdownload, kbcodesnippet, kbfile, kbinfo, kbmsxmlnosweep, KB271782

↑ Back to the top

Article Info
Article ID : 271782
Revision : 11
Created on : 4/18/2006
Published on : 4/18/2006
Exists online : False
Views : 216