The ADO.NET DataSet contains DataTableCollection and their DataRelationCollection . 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 a disconnected data source architecture. The following link gives you in details about Dataset Class with C# Source Code .