DataSet

A DataSet is a container that stores and updates data in a disconnected mode. DataSet is the most important of all ADO.NET objects. The data in a DataSet object is very secure and is never lost. DataSets provide functionality similar to stored databases but reside only in memory.

The DataSet Hierarchy

The DataSet class contains a number of other classes that enable manipulation of data stored in the Dataset. The DataSet model basically consists of the following components: tables, columns, relations, constraints, and rows. Rows represent the actual storage of data, whereas the other components compose the relational schema. A DataSet object contains a set of tables, which are derived from the DataTable class. Each DataTable class can ...

Get Special Edition Using C# now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.