What is Dataset object? Explain the various objects in Dataset

What is Dataset object? Explain the various objects in Dataset.

- 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.

What is Dataset object? Explain the various objects in Dataset.

The DataSet object represents imported or linked data from an application e.g. manually created Pushpins etc. This object is invalidated once the application is closed. Dataset contains another collection known as DataTable object. Each DataTable contains a collection of DataRow objects and each DataRow is a collection of DataColumn objects.

What are the steps involved to fill a dataset?
We fill it with data fetched from the data store. Once the work is done with the dataset, connection is reestablished....
How can we check that some changes have been made to dataset since it was loaded?
The changes made to the dataset can be tracked using the GetChanges and HasChanges methods.....
How can we add/remove row’s in “DataTable” object of “DataSet”?
How can we add/remove row’s in “DataTable” object of “DataSet”? - NewRow method is provided by the Datatable to add new row to it.DataTable has DataRowCollection object which has all rows in a DataTable object....
Post your comment