O'Reilly logo

Special Edition Using C# by NIIT

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Working with ADO

The following sections provide you with some simple tasks that can be accomplished by using ADO. The intention of this section is to bring out the differences between ADO and ADO.NET.

You can connect to any database that supports Open Database Connectivity (ODBC) through APIs. Apart from databases such as Oracle, Access, SQL Server, and Paradox databases that are ODBC-compliant, you can also access Excel spreadsheets and delimited text files, which also are ODBC-compliant. ODBC has a shortcoming in terms of not being able to fully encapsulate low-level programming.

Note

A delimited text file contains data separated by special characters, such as tab and newline characters. When an application reads data from the text file, it ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required