---
title: "DataSet in ADO.Net"  
description: "The DataSet is a memory-resident representation of data that provides a consistent relational programming model regardless of the data source. It can"  
author: "Anonymous User"  
published: 2011-07-01  
updated: 2014-09-18  
canonical: https://www.mindstick.com/blog/193/dataset-in-ado-dot-net  
category: "ado.net"  
tags: ["ado.net"]  
reading_time: 2 minutes  

---

# DataSet in ADO.Net

The DataSet is a memory-resident representation of data that provides a consistent relational [programming](https://www.mindstick.com/articles/12214/web-development-company-in-india-laid-on-the-foundation-of-concrete-java-programming) model regardless of the [data source](https://www.mindstick.com/interview/808/what-is-a-data-source). It can be used with multiple and differing data sources, with [XML data](https://www.mindstick.com/forum/149/problem-in-showing-the-xml-data-in-table-form-on-browser), or to manage data local to the application. The DataSet represents a complete set of data, including related tables, [constraints](https://www.mindstick.com/forum/34816/what-is-mapping-constraints-in-database-management-system), and [relationships](https://www.mindstick.com/blog/11850/how-to-build-stronger-relationships-with-your-employees) among the tables. DataSet only hold data and do not interact with a data source.

DataSet contains the DataTable [collection](https://www.mindstick.com/articles/1718/collections-in-java) [as well as](https://www.mindstick.com/interview/2481/can-you-write-a-java-class-that-could-be-used-both-as-an-applet-as-well-as-an-application) 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](https://www.mindstick.com/blog/194/dataadapter-in-ado-dot-net) Class. Build and fill each DataTable in a DataSet with data from a data source using a DataAdapter. The DataSet object offers [disconnected](https://www.mindstick.com/blog/300962/how-modern-life-disconnected-from-nature) 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](https://www.mindstick.com/articles/75/how-to-read-and-write-xml-file-through-c-sharp).

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

---

Original Source: https://www.mindstick.com/blog/193/dataset-in-ado-dot-net

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.