DataTableExtensions.AsDataView<T> Method (EnumerableRowCollection<T>)
Creates and returns a LINQ-enabled DataView object representing the LINQ to DataSet query.
Assembly: System.Data.DataSetExtensions (in System.Data.DataSetExtensions.dll)
public static DataView AsDataView<T>( this EnumerableRowCollection<T> source ) where T : DataRow
The type of objects in the source sequence, typically DataRow.
Usage NoteIn Visual Basic and C#, you can call this method as an instance method on any object of type EnumerableRowCollection<>. When you use instance method syntax to call this method, omit the first parameter. For more information, see Extension Methods (Visual Basic) or Extension Methods (C# Programming Guide).
DataView enables data binding scenarios for LINQ to DataSet and can be created from a LINQ to DataSet query. The DataView represents the query itself, and is not a view on top of the query. The newly created DataView infers the filtering and sorting information from the query it is created from. The DataView is then bound to a UI control, such as a DataGrid or a DataGridView, providing a simple data-binding model.
The following query operators, only, are supported in a query used to create DataView:
For more information and examples, see Creating a DataView Object (LINQ to DataSet).
The following example creates a DataView of online orders ordered by total due:
DataTable orders = dataSet.Tables["SalesOrderHeader"]; EnumerableRowCollection<DataRow> query = from order in orders.AsEnumerable() where order.Field<bool>("OnlineOrderFlag") == true orderby order.Field<decimal>("TotalDue") select order; DataView view = query.AsDataView(); bindingSource1.DataSource = view;