What is the difference between DataView, DataTable and DataSet?

Technology CommunityCategory: ADO.NETWhat is the difference between DataView, DataTable and DataSet?
VietMX Staff asked 3 years ago
  • DataTable is a collection of DataRows whose DataColumns satisfy a particular schema and may be subject to certain Constraints. As such, it is normally used as an ‘in memory’ representation of the rows, columns and constraints of a relational database table.
  • DataSet is a collection of DataTables and DataRelations between them. As such, it can be used to represent all the tables within a relational database file and the parent/child relationships between them.
  • DataView is a customized view of a DataTable for sorting, filtering, searching, editing, and navigation. It corresponds to a view (i.e. a virtual table produced by a query) in a relational database.