Commits all the changes made to this DataSet since it was loaded or since the last time was called.
Assembly: System.Data (in System.Data.dll)
Both the DataRow and DataTable classes have methods. Calling AcceptChanges at the DataTable level causes the AcceptChanges method for each DataRow to be called. Similarly, invoking on the DataSet causes AcceptChanges to be called on each table within the DataSet. In this manner, you have multiple levels at which the method can be invoked. Calling the of the DataSet enables you to invoke the method on all subordinate objects (for example, tables and rows) with one call.
When you call AcceptChanges on the DataSet, any DataRow objects still in edit-mode end their edits successfully. The RowState property of each DataRow also changes; Added and Modified rows become Unchanged, and Deleted rows are removed.
AcceptChanges and RejectChanges only apply to DataRow related changes (that is, Add, Remove, Delete, and Modify). They are not applicable to schema or structural changes.
Private Sub AcceptChanges() Dim myDataSet As DataSet myDataSet = new DataSet() ' Not shown: methods to fill the DataSet with data. Dim t As DataTable t = myDataSet.Tables("Suppliers") ' Add a DataRow to a table. Dim myRow As DataRow myRow = t.NewRow() myRow("CompanyID") = "NWTRADECO" myRow("CompanyName") = "NortWest Trade Company" ' Add the row. t.Rows.Add( myRow ) ' Calling AcceptChanges on the DataSet causes AcceptChanges to be ' called on all subordinate objects. myDataSet.AcceptChanges() End Sub
Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows XP SP2 x64 Edition, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.