DataSet in ADO.Net

The DataSet is a memory-resident representation of data that provides a consistent relational programming model regardless of the data source. It can be used with multiple and differing data sources, with XML data, or to manage data local to the application. The DataSet represents a complete set of data, including related tables, constraints, and relationships among the tables. DataSet only hold data and do not interact with a data source.

DataSet contains the DataTable collection as well as DataTable relation. It represents a complete set of data including the tables that contain, order, and constrain the data, as well as the relationships between the tables. We can use Dataset in combination with DataAdapter Class. Build and fill each DataTable in a DataSet with data from a data source using a DataAdapter. The DataSet object offers disconnected data source architecture.

Generally DataSet has two types which are namely as follows:

·   Typed DataSet:  Those Dataset which applies the information contained in the XSD to create a typed class, this DataSet is said to be a Typed Dataset. Typed DataSet are basically used to raed data from XML file.

·   Untyped DataSet: Untyped DataSet does not have any schema. It is exposed simply as a mere collection.

Last updated:9/18/2014 1:23:57 PM
Arun Singh

Arun Singh

Software Developer


Leave Comment