perfectxml.com
 Basic Search  Advanced Search   
Topics Resources Free Library Software XML News About Us
  home » Focus » MSXML » KB Articles Thu, Oct 11, 2007
NEWS
MSXML 4.0 SP2 now available!

 
MSXML
Basics
DOM
SAX
XPath
XSLT
Schemas
SOM
HTTP Access
.NET
Data Islands
Ask a Question
   Past Q&As
C++ Samples
DLL/Version Info
Reference Guide
Books
KB Articles
   HOW TO
   SAMPLE
   INFO
   BUG/PRB
   FIX
   Misc.
MSXML Tips
   August 2002
   September 2002
MSXML Tools

Microsoft XML Core Services

Select KB Articles Category:
Page: 1  2  3  4  
HOWTO: Retrieve XML Data from SQL Server 2000 with CRowsetStream

To retrieve tokenized XML data from SQL Server 2000, you must request an ISequentialStream interface during the call to the ICommand::Execute method. The Visual C++ 6.0 Active Template Library (ATL) OLE DB Consumer Templates do not provide a way to request this interface during the Execute call. This article provides information on how to create your own class to provide this functionality.
HOWTO: Use Active Server Pages to Dynamically Generate XML

This article describes how to use Active Server Pages (ASP) to dynamically create XML. The example uses an XSL style sheet to format the results. NOTE: The sample only works in XML-enabled browsers such as Microsoft Internet Explorer 5 or later.
HOWTO: Use XSL to Transform Excel XML Spreadsheet for Server-Side Use

Excel 2002 introduces new XML functionality that enables developers to extract formatted data from worksheets in an XML Spreadsheet (XMLSS) format. The Value property of a Range object can return cell formatting and contents in XMLSS. XMLSS is well-formed XML that can be loaded by the Microsoft XML Parser for manipulation at runtime. One potential use of this feature is to post XML data to a server application for processing. This article illustrates one such example, in which an Excel workbook is used as an interface for an Active Server Pages (ASP) script that processes XML data that is extracted from a range in a workbook.

This article guides you through the creation of an Excel workbook, an ASP script, and a stylesheet that all work together as an order processing system. Throughout the steps, explanations of each component and how it contributes to the whole solution are given. The sample described in this article is also available for download; for download instructions, see the "Download" section at the end of this article.
HOWTO: Include Client-Side Script Functions in an XSL Document

This article describes how you can include the DEFER attribute for the <SCRIPT> tag when you include a script function in an XSL document that is used in a client-side XML/XSL transform.
HOWTO: Retrieve Relational Data with OpenXML in an ASP Client

Running an OpenXML statement in SQL Server 2000 returns an XML data stream back to the client. This article contains a sample that prints the contents of the XML document back to the client application through an ADODB.Recordset.
HOWTO: Retrieve XML Data in ASP with the XML OLE-DB Simple Provider

This article includes step-by-step instructions to set up an ASP client that demonstrates the use of the OLEDB Simple Provider for XML to access hierarchical XML data. The OLE-DB Simple Provider for XML (XML OSP) can be used to load data in an XML document into a read-only ADO recordset. The data is then read and accessed by using the standard methods of the ADO Recordset object. This provider can be used to provide a different method of working with hierarchical data that is contained in XML documents.




HOWTO: Retrieve XML data using a Template File from within an ASP client

The sample will demonstrate exectuting a SQL 2000 template file while specifying an XSL file to transform the XML data. More specifically, a query is issued against SQL Server 2000 by using ADO 2.6's command stream. This query fetches the XML datastream.
HOWTO: Retrieve XML Data with an XPath Query in an ASP Client

This article demonstrates how to retrieve an eXtensible Markup Language (XML) data stream from a SQL Server 2000 mapping schema by using an XPath query for an Active Server Pages (ASP) client.
The sample also allows you to test XPath queries against the mapping schema. Two methods are used to show the results of the ASP XPath query.
In the first method, clicking the XPath with Parameter button calls the ASP, which in turn filters the resulting XML document based on the XPath the user supplies. This method calls the ASP page on the server each time you press the XPath with Parameters button.
In the second method, clicking the Apply XSL button loads the XML results from the ASP page into an XML data island. An Extensible Stylesheet Language (XSL) transformation is performed upon the data island and then displayed. Note that the ASP is not called until you press the XPath with Parameter button, thereby calling the ASP.
HOWTO: Retrieve XML Data by Using an XPath Query in a Visual Basic Client

This article demonstrates how to programmatically retrieve an XML data stream from a SQL Server 2000 mapping schema by using an XPath query. The scope operates in a client/server (2-tier) model. This sample also allows you to test XPath queries against the mapping schema. For each query, the form's text box displays the XML; the XML data stream's elements are broken onto separate lines for viewing purposes.
HOWTO: Display HTML in XSL Style Sheet

When XML data contains HTML tags, those tags are considered as plain data by default, and are not parsed as HTML. The output displays as text without HTML effects. This article explains how to work with the XSL style sheets to use the HTML tags that are inside XML data.
HOWTO: Obtain an ADO Recordset from XML

If you have an XML string or document you may use it to open an ActiveX Data Objects (ADO) recordset. You can do this by using the Microsoft ADO 2.5 Stream object and the new XML integration features in ADO. This article describes the mechanism required to load the following into an ADO 2.5 recordset: A string containing XML. -and- An XML DOM Document instance.
HOWTO: A C++ Sample of ADO Recordset XML Persistence

With ADO 2.5 and later, Recordset objects can be persisted into any object that implements the IStream interface. The sample code in this article shows how to persist/load ADO Recordset to/from an external xml file, ADO IStream Object and XML DOM object.




HOWTO: Persist/Load OLE DB Rowset to/from XML with ATL OLE DB Consumer Template Classes

While persistence of rowsets to XML is available through ADO, OLE DB does not provide a service for this. Similarly, OLE DB doesn't provide a service for loading an OLE DB rowset from an XML file object. To persist an OLE DB rowset as XML data, use the ADO IADORecordsetConstruction interface with an ADO Recordset object that wraps an OLE DB rowset.
XCLN: How to Create an Appointment Folder Using WebDAV

This article describes how to create an appointment folder in the default public folder store by using Distributed Authoring Version (DAV) command MKCOL. The http://schemas.microsoft.com/exchange/outlookfolderclass property of this folder is set to IPF. You create an appointment by sending an Extensible Markup Language (XML) body in the request.
HOWTO: Use an ASP Page as a Data Source for an RDS Data Control

In ADO versions 2.0 and 2.1, the Remote Data Service (RDS) data control could only be bound to a data source by specifying appropriate values for its Server, Connect and SQL parameters. ADO 2.5 and later incorporate a URL parameter for the RDS data control. The URL parameter makes it possible to bind the control to an ASP page that persists an ADO recordset to the ASP Response stream.
How to:Transmit Data between Commerce Servers with Commerce Interchange Pipeline (CIP)

This article gives an example of the steps necessary to transmit an ActiveX Data Objects (ADO) recordset on a Commerce Server computer to a Microsoft Excel spreadsheet on a different Commerce Server computer by using the Commerce Interchange Pipelines (CIPs).
HOWTO: Bind to XML Data with Internet Explorer

It is possible to bind fields on a Web page directly to an XML data source included in the page as a data island. An ASP page can generate XML, and serve as the source of data for an XML data island included in an ASP page. It is also possible to persist an ActiveX Data Objects (ADO) recordset to a stream as XML. Because the Response object in Active Server Pages (ASP) supports the IStream interface (Internet Information Server 5.0 only), an ASP page can pose as XML, and serve as the source of an XML data island. This article discusses two approaches for binding to data on a Web page to XML.
HOWTO: Offload XSL Transformations to Clients' Browsers

It is possible to offload XSL processing from the server to the client. Doing so distributes the load, which helps to relieve the server from having to process the formatting of an XML document.




HOWTO: Create XML Documents with Binary Data in Visual Basic

XML schema defines the ability to create an XML node as either bin.base64 or bin.hex, which are two forms of encoded binary. This article shows an example of how to create a XML document with nodes of bin.hex type and read the binary content from this node.
HOWTO: Use FoxPro and MSXML to Return Information About an XML Document

This is a simple example that shows how to return values from an XML document using Microsoft Visual FoxPro
Page: 1  2  3  4  


  Contact Us | E-mail Us | Site Guide | About PerfectXML | Advertise ©2004 perfectxml.com. All rights reserved. | Privacy