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.