Similar to the T-SQL SELECT statement, XQuery FLWOR statements are the foundation for querying, filtering, and sorting results from an XML document. FLWOR stands for for, let, where, order by, and return and is pronounced "flower." Although simple XPath expressions are useful, the real power of XQ... [More]

In literal XML constructors, you can use curly braces ({}) to add content that is computed when the query is run. This is called an enclosed expression. For example, in the previous example, if you want all of the <Name> elements to appear within an XML root element named <ProductNames>... [More]

XQuery is used to query an XML document, and for that you need an XML document to talk about while examining the various queries. For the purposes of this chapter, consider the XML document in Listing 1, which describes the structure of a set of products. Listing 1: Sample XML file 707... [More]

  XQuery is a fairly new language for querying XML data. It was designed from the ground up by the XML Query Working Group of the W3C with the sole purpose of querying data stored in XML format. As mentioned before, it is essentially a superset of XPath 2.0 that gives it all the features o... [More]

In .Net, modifying an XML document is a task that is central to developing XML based application (Either it is a web application or windows application). Microsoft .Net Framework has classes that can be used to perform this task. Mainly the class we used is in the namespace System.XML. In this art... [More]

Since its inception, XML has been criticized for the overhead it introduces into the enterprise infrastructure. Business data encoded in XML takes 5 to 10 times more bandwidth to transmit in the network and proportionally more disk space to store. While most agree that verbosity is inherent to XML's... [More]

Download code   Introduction This article explores the power of the DataSet in a way that you might not be familiar with. Two important (and very helpful) aspects of the DataSet are uncovered here: A DataSet can be used to write to Excel and read from Excel using an OleDbConnection ... [More]

Altova MapForce Altova MapForce 2007 is the premier visual data mapping, conversion, data transformation, and integration tool. It maps between any combination of XML, database, flat file, EDI, and/or Web service. Download:  

Introduction The eXtensible Markup Language (XML) has seen widespread adoption throughout almost every industry in recent years. Its ability to allow applications to exchange data in a standardized format through web services and XML documents, and its adoption by SQL Server 2005 and most of Micros... [More]

Download code   I have been architecting and developing solutions for many years and have benefited a lot from the internet. I can't tell you the number of times searching for something has saved me countless hours. There are so many cool articles and cool people writing them. This is why I... [More]

Compact FrameWork 2.0 doesn't provide Binary Serialization. And XML Serialization is just too simple to handle what I need: I have to deal with a complex topology of object model. Room A may be associated to Room B, and Room B to Room C, Room C to Room A, it makes a circle finally, just like this: ... [More]

Employees.xml <?xml version="1.0" encoding="utf-8" standalone="no"?> <employees> <employee id="1"> <name> <firstName>Nancy</firstName> <lastName>lastName</lastName> </name> <city>Seattle</city> <state>WA</state... [More]

Employees.xml <?xml version="1.0" encoding="utf-8" standalone="no"?> <employees> <employee id="1"> <name> <firstName>Nancy</firstName> <lastName>lastName</lastName> </name> <city>Seattle</city> <state>WA</state... [More]

Employees.xml <?xml version="1.0" encoding="utf-8" standalone="no"?> <employees> <employee id="1"> <name> <firstName>Nancy</firstName> <lastName>lastName</lastName> </name> <city>Seattle</city> <state>WA</state... [More]

Employees.xml <?xml version="1.0" encoding="utf-8" standalone="no"?> <employees> <employee id="1"> <name> <firstName>Nancy</firstName> <lastName>lastName</lastName> </name> <city>Seattle</city> <state>WA</state... [More]