O'Reilly logo

Essential ADO.NET by Bob Beauchemin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

6.5. DataViews and Common Transformations

A DataView is a view of a DataTable with a settable sort order and filtering criteria. Each DataTable contains a property that points to the DefaultView. You can set the properties of the DefaultView as well as create additional DataViews over the same DataTable. This capability is useful for exposing the same data in multiple formats without the overhead of multiple copies.

The following properties of DataView are settable:

  • Sort: a string specifying sort order.

  • RowFilter: a filter based on row values.

  • RowStateFilter: a filter based on added, deleted, modified, or current rows.

  • ApplyDefaultSort: a property that applies a default sort order based on primary key. ApplyDefaultSort works only if the Sort property ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required