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 code for recurrent conversions. New features in Version 2010!

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 Available in 32-bit and 64-bit versions Download a fully-functional trial today!