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 does not have any schema. It is exposed simply as a mere