What is the purpose of Dataset in ADO.NET?In your applications,
you might want to connect to a data store (for example, SQL Server), fetch
data, do some manipulations on the data and update the changes in datastore.
For this, the recommended approach is to connect and fetch data from data
store.
Disconnect the connection, manipulate the data and then post the changes to the data store by establishing a connection again. This approach is possible in ADO.NET using dataset object. Dataset object helps you to manipulate on set of records obtained from disconnected data store. The architecture of dataset object is shown below:
|