Difference between DataView and DataTable

DataView

1.Read-only i.e., DataView can be used to select the data.

2.Is a reference to an existing DataTable. Cannot be populated from scratch; must be instantiated with a reference to an existing DataTable.

3.Data is a reference to an existing DataTable, and does not consume space.

4.Can sort or filter rows without modifying the underlying data. Rows and columns can be hidden and revealed repeatedly.

5.Can return a DataTable version of the view

6.A live reference to a DataTable; any changes in the DataTable data is immediately reflected in the view.

7.Supports calculated columns, which are columns with a value calculated on the fly by combining or manipulating other columns.

8.Can hide or show selected columns

DataTable

1.Read/Write i.e., Datatable can be used to edit or select or delete or insert a data.

2.Can be created empty and then populated

3.Data takes storage space.

4.Can add/edit/delete rows, columns, and data, and all changes are persistent.

5.Can be cloned

6.Is source data; does not contain references

7.Does not support calculated columns

8.No row or column hiding