What is differance b/w Dataview and Datatable?

DataTable A datatable is an in-memory representation of a single database table. You can think of it as having columns and rows in the same way. The DataTable is a central object in the ADO.NET library. Other objects that use the DataTable include the DataSet and the DataView. DataView A dataview is a view on a datatable, a bit like a sql view. It allows you to filter and sort the rows - often for binding to a windows form control. Additionally, a DataView can be customized to present a subset of data from the DataTable. This capability allows you to have two controls bound to the same DataTable, but showing different versions of the data. For example, one control may be bound to a DataView showing all of the rows in the table, while a second may be configured to display only the rows that have been deleted from the DataTable. The DataTable also has a DefaultView property which returns the default DataView for the table.

data view is a control which show the record in form format, datable is a class which store the sql query result in tabular form

down vote accepted When you want to run a query and show the subset of data in a control, a DataView could help you. That's just one example, look at the MSDN example for DataView, that explains where you should use DataViews with DataTables... DataTable A datatable is an in-memory representation of a single database table. You can think of it as having columns and rows in the same way. The DataTable is a central object in the ADO.NET library. Other objects that use the DataTable include the DataSet and the DataView.

Dataview is used to filter or sort records in a data table.Datatable is a result set or collection of records in tabular format.

Dataview that allows to filter and sort the rows in the table. Datatable that has data in rows and columns

Dataview is the front end view of data,to the user in Grid view and Datatable is a temporary table to cary data from our sql server to our application

1. DataView can be used to select the data.Datatable can be used to edit or select or delete or insert a data.Means that Dataview is read only where as Datatable is read/Write. 2. Dataview is a reference to an existing DataTable.It must be instantiated with a reference to an existing DataTable.it Cannot be populated from scratch. where as Can be created empty and then populated 3. Since Dataview is a reference of datatable so it does not consume space. where as datatable's data takes storage space. 4. Dataview Can sort or filter rows without modifying the underlying data.where as datatable can add/edit/delete rows, columns, and data, and all changes are persistent. 5. Dataview supports calculated columns, which are columns with a value calculated on the fly by combining or manipulating other columns. Does not support calculated columns.

1. DataView can be used to select the data.Datatable can be used to edit or select or delete or insert a data.Means that Dataview is read only where as Datatable is read/Write. 2. Dataview is a reference to an existing DataTable.It must be instantiated with a reference to an existing DataTable.it Cannot be populated from scratch. where as Can be created empty and then populated 3. Since Dataview is a reference of datatable so it does not consume space. where as datatable's data takes storage space. 4. Dataview Can sort or filter rows without modifying the underlying data.where as datatable can add/edit/delete rows, columns, and data, and all changes are persistent. 5. Dataview supports calculated columns, which are columns with a value calculated on the fly by combining or manipulating other columns. Does not support calculated columns.