perfectxml.com
 Basic Search  Advanced Search   
Topics Resources Free Library Software XML News About Us
  You are here: home Focus SQLXML » KB Articles Sunday, 9 March 2008
 
NEWS
SQLXML 3.0 SP2 Beta 1 now available!



SQL Server 2000 XML and .NET Integration (aka SQLXML)

  SQLXML Home

  SQLXML Tutorials

  SQLXML KB Articles

  SQLXML Links

  SQLXML News


perfectxml.com Recommends
Professional SQL Server 2000 XML (Wrox Press)
Professional SQL Server 2000 XML

SQL Server 2000 XML Distilled
SQL Server 2000 XML Distilled

SQLXML KB Articles


Select KB Articles Category:
HOW TO: Use the ExecuteXmlReader Method of the SqlCommand Class in Visual C# .NET   View Q316701
You can use the ExecuteXmlReader method of the System.Data.SqlClient.SqlCommand class to load the results of SQL Extensible Markup Language (XML) queries from Microsoft SQL Server into a System.Xml.XmlReader object. You can use this method to run server-side for XML queries and to run queries that return well-formed XML data as text.
HOW TO: Use the ExecuteXmlReader Method of the SqlCommand Class in Visual Basic .NET   View Q316016
You can use the ExecuteXmlReader method of the System.Data.SqlClient.SqlCommand class to load the results of SQL Extensible Markup Language (XML) queries from Microsoft SQL Server into a System.Xml.XmlReader object. You can only use this method to run server-side for XML queries and to run queries that return well-formed XML data as text.
HOW TO: Import XML into SQL Server with the XML Bulk Load Component   View Q316005
Data that is expressed in XML can be loaded into a SQL Server 2000 database by using the XML Bulk Load component. This article outlines the steps that you need to follow to load XML data into a table that already exists in the database.
HOW TO: Do Bulk Updates and Inserts Using OpenXML with .NET Providers in Visual C# .NET   View Q315968
This article describes how to do bulk inserts and updates with different Microsoft .NET data providers by using the OpenXML method. Although the sample in this article uses the SqlClient managed provider, you can also use the OleDb or the Odbc managed provider.
HOW TO: Use XML in Connected and Disconnected ADO.NET Applications   View Q307224
Extensible Markup Language (XML) is a fundamental part of ADO.NET and Web services. This article demonstrates how to use XML in connected and disconnected ADO.NET applications. Connected ADO.NET applications can query SQL Server to return an XML result and then use the XmlReader class to iterate through the rows of XML data. Disconnected ADO.NET applications can use a DataSet object to pass data in XML format between the different tiers in a distributed system. In this article, you write an XML Web service by using ASP.NET that queries a database and returns a DataSet in XML format to the client. The client application loads the XML data into a local DataSet object and binds it to a DataGrid control. If the user changes any data, the client application posts a DiffGram to the XML Web service. The DiffGram indicates which rows have been inserted, modified, or deleted. The XML Web service uses the DiffGram to update the database. In this article, you also write a connected ADO.NET application for reporting purposes. This application uses an XmlReader class to display current information in the database.
BETA-HOWTO: XML Web Service using ASP .Net from an Office VBA Macro   View Q307033
This article demonstrates how to use an XML Web Service using ASP .Net from a Visual Basic for Applications (VBA) macro in Word or Excel.
HOW TO: Save a DataSet Class as XML   View Q301271
This document illustrates how to save relational data that is loaded into a DataSet class to a file as Extensible Markup Language (XML). This demonstrates the transition between relationally mapped data and XML data.
HOWTO: Create a BizTalk Application Integration Component to Parse XML Data into SQL Server 2000   View Q299464
This article details the steps that are required to create a BizTalk Server Application Integration Component (AIC) to parse XML data into a Microsoft SQL Server 2000 table.
HOWTO: Automate Word to Perform a Client-Side Mail Merge Using XML from SQL Server   View Q285176
This article demonstrates how to automate Microsoft Word 2000 from client-side script to perform a mail merge for labels. Word 2000 does not have a direct method for using XML data as the data source for a mail merge. The sample illustrates Active Server Pages (ASP) code that streams an XML recordset from a Web server to a client. Client-side script converts this XML data to a delimited text file that is local to the client and then automates Word to perform a mail merge using the local text file as the mail merge data source.
HOWTO: Retrieve XML Data from SQL Server 2000 with CRowsetStream   View Q281430
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: Specify Parameters for an XML Template Query from Visual Basic   View Q278872
The functionality to specify parameters for a T-SQL or XPath query is provided by enhancements in ActiveX Data Objects (ADO) 2.6. This article presents a sample of how to specify parameters to a templated query against SQL Server 2000 from an MDAC 2.6 client.
HOWTO: Specify an XSL File to Transform the XML Stream from a Query with SQL Server 2000   View Q278500
This article demonstrates how to specify an XSL file as a parameter on a post to a SQL Server 2000 virtual root.
HOWTO: Retrieve Relational Data with OpenXML in an ASP Client   View Q272271
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 by Using a SQL XML Query in an ASP Client   View Q272269
When you run an ADODB command stream and specify SQL SELECT with the FOR XML AUTO clause, an XML document stream is fetched from SQL Server, sent to the response object, and piped to the client.
HOWTO: Retrieve XML Data by Using a Template File in an ASP Client   View Q272266
The following sample demonstrates how to run 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 the command stream of ADO 2.6: This query fetches the XML datastream. This sample reads the template file products.xml from disk and sets the command text for the ADODB.Command for the query to run. Properties to be set for the ADODB.Command's Properties collection include Base Path , Output Stream , and XSL . This establishes the location where the template and XSL files reside. The Output Stream designates where the resulting XML data stream will be piped. NOTE : The Output Stream may be any object that supports an IStream or ISequentialStream interface. Objects that support the IStream interfaces are the ADODB.Stream, IIS5 Response object, and an MSXML DomDocument. Finally, the sample also sets the XSL setting in order to transform the XML document.
HOWTO: Retrieve XML Data with an XPath Query in an ASP Client   View Q272184
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 with a Template File from a Visual Basic Client   View Q271621
This sample in this article demonstrates how to retrieve an XML document from SQL Server 2000 by using a template file that contains parameters. More specifically, a query is issued against SQL Server 2000 by using an ADO 2.6 command stream. This query fetches the XML DataStream.
HOWTO: Retrieve XML Data by Using a SQL XML Query in a Visual Basic Client   View Q271620
If you run an ADODB command stream and specify SQL SELECT with the FOR XML AUTO clause, an XML document stream is fetched from SQL Server and displayed in the Visual Basic Intermediate window.
HOWTO: Retrieve XML Data by Using an XPath Query in a Visual Basic Client   View Q271619
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: Get XML Representation Of an ADO Recordset in Visual Basic   View Q252767
When you want an XML representation of a recordset you can use the new ADODB.Stream object to retrieve a string with the XML. In ADO 2.5 it is not necessary to save on a disk using the save method to retrieve the XML string generated by the recordset.
  Contact Us | E-mail Us | Site Guide | About PerfectXML | Advertise ©2004 perfectxml.com. All rights reserved. | Privacy