
The middle-tier component then updates the original data source with the changes through stored procedures. This subset is generally smaller and thus more efficiently passed back to a middle-tier component. This second DataSet object contains only the DataTable and DataRow objects that were changed, resulting in a subset of the original DataSet. That method returns a second DataSet optimized for validating and merging. In this scenario, the GetChanges method is first invoked. In a client application, it is common to have a single button that the user can click that gathers the changed data and validates it before sending it back to a middle-tier component.
GEODIST TWO DATASETS SERIES
The Merge method is typically called at the end of a series of procedures that involve validating changes, reconciling errors, updating the data source with the changes, and finally refreshing the existing DataSet. This allows the client application to have a refreshed DataSet with the latest data from the data source. A merge is typically used on a client application to incorporate the latest changes from a data source into an existing DataSet. The Merge method is used to merge two DataSet objects that have largely similar schemas. The array of DataRow objects to be merged into the DataSet. Merges a specified DataTable and its schema into the current DataSet, preserving or discarding changes in the DataSet and handling an incompatible schema according to the given arguments. Merge(DataTable, Boolean, MissingSchemaAction) Merges a specified DataSet and its schema with the current DataSet, preserving or discarding changes in the current DataSet and handling an incompatible schema according to the given arguments. Merge(DataSet, Boolean, MissingSchemaAction) Merges an array of DataRow objects into the current DataSet, preserving or discarding changes in the DataSet and handling an incompatible schema according to the given arguments. Merge(DataRow, Boolean, MissingSchemaAction) Merges a specified DataSet and its schema into the current DataSet, preserving or discarding any changes in this DataSet according to the given argument. Merges a specified DataTable and its schema into the current DataSet. Merges a specified DataSet and its schema into the current DataSet. Merges an array of DataRow objects into the current DataSet.

Merges a specified DataSet, DataTable, or array of DataRow objects into the current DataSet or DataTable.
