DataTableExtensions.AsDataView Method (DataTable)


The .NET API Reference documentation has a new home. Visit the .NET API Browser on to see the new experience.

Creates and returns a LINQ-enabled DataView object.

Namespace:   System.Data
Assembly:  System.Data.DataSetExtensions (in System.Data.DataSetExtensions.dll)

Public Shared Function AsDataView (
	table As DataTable
) As DataView


Type: System.Data.DataTable

The source DataTable from which the LINQ-enabled DataView is created.

Return Value

Type: System.Data.DataView

A LINQ-enabled DataView object.

DataView enables data-binding scenarios for LINQ to DataSet and can be created from a typed or untyped DataTable, providing a default view of that table. Filtering and sorting can be set on the DataView after it has been created from a DataTable. The DataView is then bound to a UI control, such as a DataGrid or a DataGridView, providing a simple data binding model.

For more information and examples, see Creating a DataView Object (LINQ to DataSet).

The following example creates a DataView from the SalesOrderDetail table and sets it as the data source of a BindingSource object, which acts as a proxy for a DataGridView control:

Dim orders As DataTable = dataSet.Tables("SalesOrderDetail")

Dim view As DataView = orders.AsDataView()
bindingSource1.DataSource = view

.NET Framework
Available since 3.5
Return to top