Share via


How to: Get Specific Versions of a DataRow

When changes are made to data rows, the dataset retains both the original (Original) and new (Current) versions of the row. For example, before calling the AcceptChanges method, your application can access the different versions of a record (as defined in the DataRowVersion enumeration) and process the changes accordingly.

Note

Different versions of a row exist only after it has been edited and before it has had the AcceptChanges method called. After the AcceptChanges method has been called, the current and original versions are the same.

Passing the DataRowVersion value along with the column index (or column name as a string) returns the value from that column's particular row version. The changed column is identified during the ColumnChanging and ColumnChanged events, so that is a good time to inspect the differing row versions for validation purposes. However, if you have temporarily suspended constraints, those events will not be raised and you will need to programmatically identify which columns have changed. You can do this by iterating through the Columns collection and comparing the different DataRowVersion values.

Accessing the Original Version of a DataRow

To get the original version of a record

  • Access the value of a column passing in the DataRowVersion of the row you want to return.

    The following example shows how you can use a DataRowVersion value to get the original value of a CompanyName field in a DataRow:

    Dim originalCompanyName As String
    originalCompanyName = NorthwindDataSet1.Customers(0) _
        ("CompanyName", DataRowVersion.Original).ToString()
    
    string originalCompanyName;
    originalCompanyName = northwindDataSet1.Customers[0]
        ["CompanyName", DataRowVersion.Original].ToString();
    

Accessing the Current Version of a DataRow

To get the current version of a record

  • Access the value of a column and add a parameter to the index indicating which version of a row you want to return.

    The following example shows how you can use a DataRowVersion value to get the current value of a CompanyName field in a DataRow:

    Dim currentCompanyName As String
    currentCompanyName = NorthwindDataSet1.Customers(0) _
        ("CompanyName", DataRowVersion.Current).ToString()
    
    string currentCompanyName;
    currentCompanyName = northwindDataSet1.Customers[0]
        ["CompanyName", DataRowVersion.Current].ToString();
    

See Also

Concepts

What's New in Data

Displaying Data Overview

Other Resources

Editing Data in Your Application

Validating Data

Saving Data

Data Walkthroughs

Getting Started with Data Access

Connecting to Data in Visual Studio

Preparing Your Application to Receive Data

Fetching Data into Your Application

Displaying Data on Forms in Windows Applications