This sample illustrates how to produce XML from SQL Server using two different techniques. The first uses the ExecuteXmlReader method of SqlCommand to get an XmlTextReader, which is then populated into a DataSet using the ReadXml method of the DataSet class. The second uses the SqlDataAdapter to ext

(Bob DuCharme) Amazon Web Services (AWS) provide two ways to get XML versions of the information that Amazon’s customers ordinarily get from HTML web pages: a SOAP interface and a REST interface. It’s nice to see the pains that Amazon takes to make it clear that, when it says “web services” it doesn

(Frank Rice) Learn different ways to transfer data from an Access database to Microsoft Office Excel 2003. These include using the user-interface, programmatically creating an XML file, transforming the data and reading it into Excel, and automating Excel and programmatically reading the data file.

(James Edmunds) “Don’t you have it set up so you can just automatically pull our listings from our Web sites?” the e-mail asked. “Not yet,” I typed in my response. “But it’s a great idea, and I’m working on it now.”

(Aaron Skonnard) How can I merge the contents of multiple XML files into one? There are a variety of ways to accomplish this with the Microsoft .NET Framework, each of which uses a different type of XML API. To do this with the DOM API, you need to use the ImportNode function for copying XmlNode

(Jack Herrington) E4X is a new standard for XML access in ECMAScript (JavaScript). Recently, I had the good fortune to meet some folks on the steering committee and to sample a demo. The idea is simple — XML access using SAX or DOM is too difficult, so make it easier.

Microsoft, with the release of Web Part and Web services toolkits for its SharePoint Products, continues to advance interoperability of enterprise applications. The software giant mounts another push in its on-going efforts aimed at setting XML Web services standards. Moreover, with the introduction

(Edd Dumbill) While XML’s noblest and best are away directly injecting their brains with mind-altering drugs at Extreme Markup, there’s still plenty of food for thought for the rest of us from last week’s XML mailing lists and weblogs.

(David Miller) The process of formatting and typesetting documents has come a long way in the relatively short span of time that modern computers have been around; the process has typically revolved around formatting scientific or technical documents using a variety of command-line tools. However, t

(John E. Simpson) I need to translate text in an XML document from English to Dutch. The XML document in question is used as a language file in vBulletin forum software. The problem is that I have to get the text to be translated out of the XML code and, after translation, back into the code in the