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.