ADO Examples

Display

Display records
Display records in an HTML table
Add headers to the HTML table
Add colors to the HTML table

Queries

Display records where "Companyname" starts with an A
Display records where "Companyname" is > E
Display only Spanish customers
Let the user choose filter

Sort

Sort the records on a specified fieldname ascending
Sort the records on a specified fieldname descending
Let the user choose what column to sort on

Recordset Object

GetRows
GetString

Altova® MapForce®
Graphical XML Mapping Tool from the Developers of XMLSpy®

Need an easy way to get data into XML, or transform XML to another format? MapForce lets you map XML data to/from any combination of XML, database, flat file, Excel 2007, XBRL, or Web services data. Then it transforms data instantly or auto-generates royalty-free data integration code for recurrent conversions.

Download a free, fully functional 30-day trial to experience the following features: Easy-to-use, graphical data mapping interface Instant data transformation XSLT 1.0/2.0 and XQuery code generation Java, C#, and C++ code generation Advanced data processing functions Support for all major relational databases including SQL Server, IBM DB2, Oracle, and more Visual Studio & Eclipse integration Download a fully-functional trial today!