X SL Transformations (XSLT) is known for making hard things easy and easy things hard. It can simplify complex transformation logic that would be extremely tedious to implement otherwise. But at the same time, XSLT's functional programming model can sometimes make it extremely difficult to perform trivial business logic. Often extending XSLT with traditional languages like VBScript, JScript®, or any Microsoft® .NET-supported language can offer the best of both worlds (for an introduction to XSLT see the article that I cowrote with Don Box and John Lam in the August 2000 issue).

This sample application shows how to load a DataSet with records from two tables in a SQL Server database, create relationships between the tables within the DataSet, and then use the Nested property so that the resulting XML structure is nested in a hierarchical manner. The resulting nested XML structure is then transformed to HTML using an XSLT stylesheet.

In this source code I am going to show how to apply xslt to data coming from a database in xml format.

An approach to transform any type of data source to XML.

This example illustrates JMS and XSLT for e-buisness messaging.

This page contains an example to render a connected tree using XSLT.

This example will show you to use advance XSLT techniques.

This section will show you to add dynamic attributes to output elements to create HTML links and anchors.

This section contains an example to dynamic SQL generation using XSLT.

This section presents a technical solution to manage a client's large volume of data feeds.

Is XSL-FO the 'Next big thing' to present XML data ?

This is the 5th part of the series Got XSLT. This part contains an example to transform XML to PDF using FOP.

An examle using XML and XSL transformation to create a WAP compatible WML file.

This section contains an example to create a sortable HTML tables using XSLT.

This section contains an example to develope complex XSLT scripts.

This example demonstrates using XSLT to output text files (as opposed to the usual HTML or XML files). Assume we have been given the following set of XML records and their schema and wish to store them in a database. Most relational databases support some kind of text-based import utility for just this purpose. In this example, we will transform the above XML files into two data files suitable for use with Microsoft SQL Server's command-line BCP (Bulk Copy Program) utility. We will have to convert the input XML into a comma-delimited DAT file, and an input XML schema into a space-delimited FMT file.

An example. We will now use XSLT to define a transformation from our article-class of XML documents (see article.dsd) into HTML.

Foil 26 XSL Patterns

Foil 24 XSL - Example.

Learning by example is sometimes the easiest way to explore new technologies. Every week under this section you'll find 5 examples that you can try out and hopefully learn something new!