DataSet <-> Data Source

The connection between the DataSet and the data source is usually provided with a DataAdapter. Once a DataSet has got the data it is disconnected from the data source, whatever changes you make to the data are kept in the DataSet until you update the data source.

States:

• Original This state is how the data was when it first came into the dataset. This cannot be modified, if you try to modify it, its put into one of the other two states.

• Current This state is the data when you modify it, it holds the modified rows.

• Proposed This state is the proposed data to be sent to the data source. The difference between this and the Current State is that this one is entered by using Edit Mode and imposes the rules of the data source immediately (the Current only enforces them when it updates the dataset).

You don't really need to worry about these, what we'll be concentrating on is the the current data (with changes).