Connecting and Retrieving Data in ADO.NET 

A primary function of any database application is connecting to a data source and retrieving the data that it contains. The .NET Framework data providers of ADO.NET serve as a bridge between an application and a data source, allowing you to execute commands as well as to retrieve data by using a DataReader or a DataAdapter.

In This Section

Connecting to Data Sources

Describes the ADO.NET Connection object and how to use it to connect to a data source.

Working with Connection Strings

Describes various aspects of using connection strings including connection string keywords, security info, and storing and retrieving them.

Working with Commands

Describes the ADO.NET Command object and how to use it to execute commands and return results from a data source.

Working with DataAdapters

Describes the ADO.NET DataAdapter object and how to use it to retrieve data from a data source and populate tables within a DataSet.

Working with DataReaders

Describes the ADO.NET DataReader object and how to use it to retrieve a read-only, forward-only stream of data from a data source.

Obtaining Schema Information from a Database

Describes how to obtain available databases or catalogs, tables and views in a database, constraints that exist for tables, and other schema information from a data source.

Related Sections

What's New in ADO.NET

Introduces new features in ADO.NET.

Overview of ADO.NET

Provides an introduction to the design and components of ADO.NET.

Securing ADO.NET Applications

Describes secure coding practices when using ADO.NET.

Using DataSets in ADO.NET

Describes how to create and use DataSets, typed DataSets, DataTables, and DataViews.

Modifying Data in ADO.NET

Describes how to modify data in a database and how to use transactions.

Using the .NET Framework Data Provider for SQL Server

Describes how to work with features and functionality that are specific to SQL Server.

Using the .NET Framework Data Provider for Oracle

Describes features and behaviors that are specific to the .NET Framework Data Provider for Oracle.

Using SQL Server Common Language Runtime Integration

Describes how data can be accessed from within a common language runtime (CLR) database object in SQL Server 2005.

Writing Provider Independent Code in ADO.NET

Describes generic classes that allow you to write provider-independent code in ADO.NET.

Performing General Tasks in ADO.NET

Describes how to use various general-purpose features of ADO.NET.

Finding Additional ADO.NET Information

Provides links to additional online information about ADO.NET.

See Also

Other Resources