Validating Data

Datasets provide specific events that are raised as values in data rows change. Event handlers can be created (in partial classes) to validate these changes based on your particular application requirements. The following topics detail these events and provide an explanation of the information passed to each event.

In This Section

• Data Validation Overview
  Provides an overview of events that can be used to analyze data before being committed to the dataset.

• How to: Validate Data During Column Changes
  Describes how to validate data during the ColumnChanging event.

• How to: Validate Data During Row Changes
  Describes how to validate data during the RowChanging event.

• Walkthrough: Adding Validation to a Dataset
  Provides step by step information for adding validation code to a dataset.

Reference

• ColumnChanging
  The event that is raised when data in a column is about to be changed.

• RowChanging
  The event that is raised when data in a data row is about to be changed.

Related Sections

• Handling DataTable Events (ADO.NET)
  Provides information about the events available for use with a DataTable, including events when column values are modified and rows are added or deleted.

• Handling and Raising Events
  Provides links to topics and information on event handlers.

• Getting Started with Data Access
  Provides links to topics on creating applications that work with data, using Visual Studio.

• Partial (Visual Basic)
  Provides information on partial classes in Visual Basic.

• partial (Type) (C# Reference)
  Provides information on partial classes in C#.

• Preparing Your Application to Receive Data
  Provides links to topics 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 topics 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 topics that explain how to display data on Windows Forms through data-bound controls.

• Editing Data in Your Application
  Provides links to topics describing how to manipulate the data in the data tables of a dataset.

• Saving Data
  Provides links to topics explaining how to send updated data from an application to the database.