Implements an in-memory cache of data read from a data source [Edit]

See Also: DataSet Members

System.Object
     System.ComponentModel.MarshalByValueComponent
          System.Data.DataSet

[System.Xml.Serialization.XmlRoot("DataSet")] [System.Xml.Serialization.XmlSchemaProvider("GetDataSetSchema")] [System.ComponentModel.Designer("Microsoft.VSDesigner.Data.VS.DataSetDesigner, Microsoft.VSDesigner, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a", "System.ComponentModel.Design.IDesigner")] [System.ComponentModel.DefaultProperty("DataSetName")] [System.ComponentModel.ToolboxItem("Microsoft.VSDesigner.Data.VS.DataSetToolboxItem, Microsoft.VSDesigner, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")] public class DataSet : System.ComponentModel.MarshalByValueComponent, System.ComponentModel.IListSource, System.ComponentModel.ISupportInitializeNotification, System.Runtime.Serialization.ISerializable, System.Xml.Serialization.IXmlSerializable

Remarks

DataSet, composing a part of the ADO.NET framework, is a class which represents a "snapshot" of data read from a certain, arbitrary, data source and defines operations that let the programmer access and manipulate the data in the relational. The data sources DataSet can use range from RDBMS to XML files.

Data is kept in a collection of System.Data.DataTable objects which you can relate to each other thanks to the System.Data.DataRelation class. Data integrity can be enforced in the fashion similar to the RDBMS, using the constraint classes - System.Data.UniqueConstraint and System.Data.ForeignKeyConstraint.

Numerous other ways of manipulating the data exist with the DataSet. It is possible to retrieve a subset of the data that contains only the data that was changed in the current DataSet, one can also merge DataSets, update the data in one DataSet using another DataSet as a source, add, delete and updata rows of data represented by the System.Data.DataRow class. It is also possible to reject or accept the changes to the data using, respectively, the DataSet.AcceptChanges and the DataSet.RejectChanges methods.

[Edit]

Requirements

Namespace: System.Data
Assembly: System.Data (in System.Data.dll)
Assembly Versions: 1.0.3300.0, 1.0.5000.0, 2.0.0.0