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 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 Data by 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.

Related Sections

• 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.

• Validating Data
  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.

• Updating Data Sources with DataAdapters (ADO.NET)
  Describes how to resolve changes made to data in a DataSet back to the data source using a DataAdapter.