The pages in this section describe the concepts and tasks associated with saving data from your application to a database.
In This Section
Saving Data Overview
Provides an overview of how changes are made in a dataset and how the dataset tracks information about changes in order to update a database with new or modified records.
How to: Save Dataset Changes to a Database
Provides details on sending updated data back to a database using TableAdapters and data adapters.
How to: Update Data by Using a TableAdapter
Provides details on sending updated data back to a database using TableAdapters.
How to: Insert New Records into a Database
Provides details on creating new records in a database.
How to: Update Records in a Database
Provides details on sending modified records back to the database.
How to: Delete Records in a Database
Provides details on removing records from a database.
How to: Directly Access the Database with a TableAdapter
Provides details for calling methods on a TableAdapter that modify data directly in the database.
How to: Save Data from an Object to a Database
Provides details on using a TableAdapter to save object data to a database.
How to: Save a Dataset as XML
Provides details for saving the data in a dataset as XML.
Walkthrough: Saving Data with the TableAdapter DBDirect Methods
Provides step-by-step instructions for directly sending commands to a database.
Walkthrough: Saving Data to a Database (Single Table)
Provides step by step details for saving modified data in a data table to the underlying database.
Walkthrough: Saving Data to a Database (Multiple Tables)
Provides step-by-step details for saving modified data in two related data tables to the underlying database.
Walkthrough: Saving Data in a Transaction
Provides step-by-step details for saving data using the System.Transactions namespace.
Concurrency Control in ADO.NET
Provides links to pages describing what concurrency is and how it is handled in ADO.NET.
Represents a unique session to a SQL Server data source.
Contains classes that allow you to write your own transactional application and resource manager.
Getting Started with Data Access
Provides links to pages on creating applications that work with data, using Visual Studio.
Preparing Your Application to Receive Data
Provides links to pages explaining what datasets are, how to create new datasets, and how to create and edit the individual objects they are made of.
Fetching Data into Your Application
Provides links to pages describing how to load data into datasets and how to execute SQL statements and stored procedures.
Displaying Data on Forms in Windows Applications
Provides links to pages that explain how to display data on Windows Forms through data-bound controls.
Editing Data in Your Application
Provides links to pages describing how to manipulate the data in the data tables of a dataset.
Provides links to pages describing how to add validation to a dataset during column and row changes.
.NET Framework Data Providers (ADO.NET)
Discusses the design of a .NET Framework data provider in general and lists the providers that are included with ADO.NET.