Modifying Data in ADO.NET
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

Modifying Data in ADO.NET 

.NET Framework 2.0

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

Using Stored Procedures to Update Data

Describes how to use input, output, and return values from a stored procedure by using a DataAdapter and a DataSet.

Updating Data Sources with DataAdapters

Describes how to use a DataAdapter to resolve changes in a DataSet back to the database.

Retrieving Identity or Autonumber Values

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.

Working with DataAdapter Events

Describes DataAdapter events and how to use them.

Performing Batch Operations Using DataAdapters

Describes enhancing application performance by reducing the number of round trips to SQL Server when applying updates from the DataSet.

Updating Data Sources with Commands

Describes how to use a data provider to execute stored procedures or data definition language (DDL) statements.

Performing Transactions

Describes how to perform database transactions using ADO.NET.

Related Sections

What's New in ADO.NET

Introduces features that are new 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.

Connecting and Retrieving Data in ADO.NET

Describes how to connect to a data source and retrieve data, including DataReaders and DataAdapters.

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

ADO.NET

Show:
© 2016 Microsoft