Saving Data
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 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 Data using a Transaction
-
Provides details for saving data using the System.Transactions namespace.
- 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.
Reference
- System.Data
-
Describes the System.Data namespace and provides a table of relevant classes.
- DataSet
-
Describes the DataSet class and provides information and links about its members.
- SqlConnection
-
Represents a unique session to a SQL Server data source.
- SqlDataAdapter
-
Represents a set of data commands and a database connection that are used to fill the DataSet and update a SQL Server database.
- System.Transactions
-
Contains classes that allow you to write your own transactional application and resource manager.