(c) 2002 Visual Studio Magazine
Fawcette Technical Publications

Issue: August 2002
Section: Database Design
Author: Bill Wagner

C#	Get the Changes From the DataSet
Listing 1	The DataSet keeps track of all your users' changes for you.  You can get sets of changes from the DataSet based on the kind of change.  You can then work with these subsets separately.

if (employeeDataSet1.HasChanges ())
{
	changes = employeeDataSet1.GetChanges 
		(DataRowState.Modified);
	ChangedRows.DataSource = changes;  
	ChangedRows.DataMember = "Employees";

	InsertedRows.DataSource = 
		employeeDataSet1.GetChanges 
		(DataRowState.Added);

	InsertedRows.DataMember = "Employees";

	DataSet delRows = employeeDataSet1.GetChanges 
		(DataRowState.Deleted);

	// In this copy, undelete all the rows so 
	// that the data grid displays them.
	if (delRows != null)
		delRows.RejectChanges ();
	DeletedRows.DataSource = delRows;
	DeletedRows.DataMember = "Employees";

	} 
	else
	{
		ChangedRows.DataSource = null;
		ChangedRows.DataMember = null;
		InsertedRows.DataSource = null;
		InsertedRows.DataMember = null;
	}
}

