
When binding a control to more than one table of a DataSet, binding to a DataViewManager is the ideal choice. The DataViewManager provides you with a convenient way to manage default view settings for each table. You can use a DataViewManager to manage view settings for all the tables in a DataSet. You also cannot exclude columns that exist in the source table or append columns that do not exist in the source table, such as computational columns. Unlike a database view, however, a DataView cannot be treated as a table and cannot provide a view of joined tables. The dynamic capabilities of the DataView make it ideal for data-binding applications.Ī DataView provides you with a dynamic view of a single set of data, much like a database view, to which you can apply different sorting and filtering criteria.

This behavior differs from the Select method of the DataTable, which returns a DataRow array from a table based on a particular filter and/or sort order: this content reflects changes to the underlying table, but its membership and ordering remain static. Using a DataView, you can expose the data in a table with different sort orders, and you can filter the data by row state or based on a filter expression.Ī DataView provides a dynamic view of data in the underlying DataTable: the content, ordering, and membership reflect changes as they occur. A DataView enables you to create different views of the data stored in a DataTable, a capability that is often used in data-binding applications.
