ADO.NET 3.5 Cookbook, 2nd Edition

6.16. Converting a DataSet to an ADO Recordset

Problem

You need to convert a DataSet to an ADO Recordset so that you can use it in a legacy application.

Solution

Persist the DataSet to XML, transform it to an ADO Recordset schema, and load it into an ADO Recordset.

The solution converts the DataSet to an ADO Recordset using the following steps:

1. A shell XML document for the ADO Recordset is created.

2. A DataReader accesses the schema information for the data to convert using the GetSchemaTable() method. This information is mapped to and added to the ADO Recordset XML document.

3. The DataSet is loaded with data for a single DataTable. The XML document for the DataSet is transformed and written into the ADO Recordset XML document.

4. An ADO Recordset object is created and loaded with the ADO Recordset XML document. This completes the conversion.

5. The ADO Recordset is loaded into a DataTable using the OleDbDataAdapter. The default view for the table is bound to the data grid on the form to display the results of the conversion.

The GetDataTypeInfo() method maps SQL Server specific types to data type attributes for the ds and rs namespaces used to serialize an ADO Rowset.

The solution uses one XSLT stylesheet Department.xslt to transform the XML document output by the DataSet into an ADO Recordset XML document.

The XSLT file is shown in Example 6-16.

Example 6-16. File: Department.xslt

<?xml version="1.0" ?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:rs="urn:schemas-microsoft-com:rowset" ...