Export (0) Print
Expand All

DataTable.DefaultView Property

Gets a customized view of the table that may include a filtered view, or a cursor position.

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

[BrowsableAttribute(false)]
public DataView DefaultView { get; }

Property Value

Type: System.Data.DataView
The DataView associated with the DataTable.

The DefaultView property returns a DataView you can use to sort, filter, and search a DataTable.

The following example sets a property of the DataTable object's DataView through the DefaultView property. The example also shows the binding of a DataGridView control to a DataTable named "Suppliers" that includes a column named "CompanyName."

private void BindDataGrid()
{
    DataTable table = new DataTable();

    // Insert code to populate a DataTable with data. 

    // Bind grid to DataTable.
    dataGrid1.DataSource = table;
}

private void ChangeRowFilter()
{
    DataTable gridTable = (DataTable) dataGrid1.DataSource;

    // Set the RowFilter to display a company names that  
    // begin with A through I..
    gridTable.DefaultView.RowFilter = "CompanyName < 'I'";
}

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0, 1.1

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

XNA Framework

Supported in: 3.0, 2.0, 1.0
Show:
© 2015 Microsoft