ADO Programming Examples

The following programming snippets demonstrate how to specify the arguments to the ADO calls for the Scantron OLE DB Provider (Scantron.Oledb). These are examples of some typical settings and are not necessarily the only way to complete your programming objectives.

TIP: Refer to the MSDN for more ADO programming examples.

NOTE:Do not confuse a data file record with the ADO record object in the examples.

Open an ADO connection to a DAT file

Open an ADO Recordset for a Generic Data File

Specify connection information using a Universal Data Link (UDL) file

Open an ADO recordset for a single document data file

Execute a command on an ADO connection

Open an ADO record object that represents one record within the *.dat file

Open an ADO recordset object using a URL

Open an ADO recordset on the children of a record object that models a collection

Open an ADO Record on a row in an ADO recordset

Open an ADO connection for retrieving application definition information

Open an ADO recordset on a schema rowset

Open an ADO recordset on a schema rowset using restrictions

Open an ADO record on a data record at scan time

Open an ADO recordset on a data record at scan time

Search an ADO recordset for data matching a single field

Filter an ADO recordset using criteria

Open a connection to a memory resident source of scanned data

Populate a data grid at runtime with the contents of an ADO recordset

Save scanned data to file in XML format

Search for a data record via an ADO recordset

Delete data record via an ADO recordset

Modify a data record via an ADO Recordset

Sort data records

ADO Example--Append new data records to a data file using an INSERT command

ADO Example--Buffer a live data stream when using an ADO Recordset

ADO Example--Output a data record in comma separated values (CSV) format

 

 

See Help on Help for additional information on using this help file.

See Scantron Technical Support for additional information on technical support and training options.

See the ScanTools Suite System Requirements for further details on hardware and software requirements.

ScanTools is a suite of products; the specific information you want may appear in the help for a different module. If you don't find what you're looking for here, try one of the following:

 

Scantron Corporation

Customer Service (forms, products, and services):

1-800-SCANTRON (722-6876)

www.scantron.com

Technical Support:

1-800-445-3141

support@scantron.com

Copyright © 1998-2012 Scantron Corporation. All rights reserved. Use permitted only under license. www.scantron.com. No part of the Help or user guides may be reproduced in any form, or by any means, without express permission from Scantron Corporation.

LINKS TO THIRD PARTY SITES

This help system may contain links to third party websites ("Linked Sites"). The Linked Sites are not under the control of Scantron and Scantron is not responsible for the content of any Linked Site, including without limitation any link contained in a Linked Site or any changes or modifications to a Linked Site. Scantron is not responsible for web casting or any other form of transmission received from any Linked Site. Scantron provides Users with the ability to link the Assessment System to the Linked Sites as a convenience to you, and the inclusion of any link does not imply endorsement by Scantron of the Linked Site or any association with its operators.