Export (0) Print
Expand All
10 out of 20 rated this helpful - Rate this topic

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.

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

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

Describes how to resolve changes made to data in a DataSet back to the data source using a DataAdapter.

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.