Export (0) Print
Expand All

Creating and Using DataViews 



A 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. Unlike a database view, however, a DataView cannot be treated as a table and cannot provide a view of joined tables. You also cannot exclude columns that exist in the source table, nor can you append columns, such as computational columns, that do not exist in the source table.

You can use a DataViewManager to manage view settings for all the tables in a DataSet. The DataViewManager provides you with a convenient way to manage default view settings for each table. When binding a control to more than one table of a DataSet, binding to a DataViewManager is the ideal choice.

In This Section

Creating a DataView

Describes how to create a DataView for a DataTable.

Sorting and Filtering Data Using a DataView

Describes how to set the properties of a DataView to return subsets of data rows meeting specific filter criteria, or to return data in a particular sort order.

Viewing Data Using a DataView

Describes how to access the contents of a DataView, find a particular data row in a DataView, and create views of data from parent-child relationships.

Modifying Data Using a DataView

Describes how to modify the data in the underlying DataTable via the DataView, including enabling or disabling updates.

Working with DataView Events

Describes how to use the ListChanged event to receive notification when the contents or order of a DataView is being updated.

Setting Default Table Views Using a DataViewManager

Describes how to use a DataViewManager to manage DataView settings for each table in a DataSet.

Related Sections

ASP.NET Web Applications in the .NET Framework

Provides overviews and detailed, step-by-step procedures for creating ASP.NET applications, Web Forms, and Web Services.

Windows-based Applications

Provides detailed information about working with Windows Forms and console applications.

Using DataSets in ADO.NET

Describes the DataSet object and how you can use it to manage application data.

Creating and Using DataTables

Describes the DataTable object and how you can use it to manage application data by itself or as part of a DataSet.


Describes the ADO.NET architecture and components, and how to use ADO.NET to access existing data sources and manage application data.

Community Additions

© 2014 Microsoft