This documentation is archived and is not being maintained.

Dataset Updates in Visual Studio .NET

Visual Studio .NET 2003

When you work with datasets — disconnected stores of records residing in memory — there are a number of issues associated with updating. When data is modified in a dataset, the dataset tracks those changes. You can then send dataset changes to other processes, such as the original data source or some other component. Throughout the update process there are several raised events where data validation, concurrency evaluation, and application logic can be applied.

Note   In Windows Forms, the data-binding architecture takes care of sending changes from data-bound controls to the dataset, and you do not have to explicitly update the dataset with your own code. For more information, see Windows Forms Data Architecture.

The topics in this section describe how dataset updates work and how to update, insert, and delete records in a dataset as well as the underlying data source.

Note   When you deploy an application that includes Visual Studio data-access components, you must make sure that the user installing the application has version 2.7 or later of the Microsoft Data Access Components (MDAC). For more information, see Adding a Launch Condition for Microsoft Data Access Components.

In This Section

Introduction to Dataset Updates
Provides an overview of how changes are made in a dataset and how the dataset tracks information about changes in order to send change information to other processes.
Updating, Inserting, and Deleting Records in a Dataset
Provides links to procedural topics detailing how to update data in datasets.
Writing Dataset Changes to a Data Source
Provides links to topics that describe how to update a database with the contents of a dataset.
Concurrency Control in ADO.NET
Provides links to topics describing what concurrency is and how it is handled in ADO.NET.

Related Sections

ADO.NET Datasets
Provides topics about what datasets are and how to use them.
Adding New Data Connections in Server Explorer
Describes how to create a design-time connection.
Creating and Filling Datasets Example Topics
Presents a series of specific example code topics for common tasks in creating and filling datasets with Visual Basic .NET.
Manipulating Data Example Topics
Presents a series of specific example code topics for common tasks in working with data within your application using Visual Basic .NET.
Configuring Applications Using Dynamic Properties
Provides conceptual information about storing property values in a configuration file that can be changed at run time, which is particularly useful for connection information such as server name and user name.
Accessing Data
Provides links to information about working with ADO.NET in Visual Basic and Visual C#.
System.Data Namespace
Describes the System.Data namespace and provides a table of relevant classes.
DataSet Class
Describes the DataSet class and provides information and links about its members.
Concurrency Control in ADO.NET
Provides links to topics that explain what concurrency is, as well as strategies for handling concurrency issues.
Adding a Launch Condition for Microsoft Data Access Components
Describes how to check that the correct version of the ADO.NET data access components is available when you install your application.