4 out of 5 rated this helpful - Rate this topic

Retrieving and Modifying Data in ADO.NET

.NET Framework 4

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. A key function of any database application is the ability to update the data that is stored in the database. In ADO.NET, updating data involves using the DataAdapter and DataSet, and Command objects; and it may also involve using transactions.

In This Section

Connecting to a Data Source (ADO.NET): Describes how to establish a connection to a data source and how to work with connection events.
Connection Strings (ADO.NET): Contains topics describing various aspects of using connection strings, including connection string keywords, security info, and storing and retrieving them.
Connection Pooling (ADO.NET): Describes connection pooling for the .NET Framework data providers.
Commands and Parameters (ADO.NET): Contains topics describing how to create commands and command builders, configure parameters, and how to execute commands to retrieve and modify data.
DataAdapters and DataReaders (ADO.NET): Contains topics describing DataReaders, DataAdapters, parameters, handling DataAdapter events and performing batch operations.
Transactions and Concurrency (ADO.NET): Contains topics describing how to perform local transactions, distributed transactions, and work with optimistic concurrency.
Retrieving Identity or Autonumber Values (ADO.NET): Provides an example of mapping the values generated for an identity column in a Microsoft SQL Server table or for an Autonumber field in a Microsoft Access table, to a column of an inserted row in a table. Discusses merging identity values in a DataTable.
Retrieving Large Data (ADO.NET): Describes how to retrieve binary data or large data structures using CommandBehavior.SequentialAccess to modify the default behavior of a DataReader.
Modifying Data with Stored Procedures (ADO.NET): Describes how to use stored procedure input parameters and output parameters to insert a row in a database, returning a new identity value.
Retrieving Database Schema Information (ADO.NET): 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.
DbProviderFactories (ADO.NET): Describes the provider factory model and demonstrates how to use the base classes in the System.Data.Common namespace.
Data Tracing in ADO.NET: Describes how ADO.NET provides built-in data tracing functionality.
Performance Counters (ADO.NET): Describes performance counters available for SqlClient and OracleClient.

Other Resources

Data Type Mappings in ADO.NET

DataSets, DataTables, and DataViews (ADO.NET)

Securing ADO.NET Applications

SQL Server and ADO.NET

ADO.NET Managed Providers and DataSet Developer Center

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)