Interview answers verified by specialists.
Find interview questions and answers on this website:
The DataSet object is a disconnected storage. It is used for manipulation of relational data. The DataSet is filled with data from the store We fill it with data fetched from the data store. Once the work is done with the dataset, connection is reestablished and the changes are reflected back into the store. Dataset has a collection of Tables which has DataTable collection which further has DataRow DataColumn objects collections. It also has collections for the primary keys, constraints, and default values called as constraint collection. A DefaultView object for each table is used to create a DataView object based on the table, so that the data can be searched, filtered or otherwise manipulated while displaying the data.