DataView Constructors

Definition

Namespace:

System.Data

Assembly:

System.Data.Common.dll

Initializes a new instance of the DataView class.

Overloads

DataView()	Initializes a new instance of the DataView class.
DataView(DataTable)	Initializes a new instance of the DataView class with the specified DataTable.
DataView(DataTable, String, String, DataViewRowState)	Initializes a new instance of the DataView class with the specified DataTable, RowFilter, Sort, and DataViewRowState.

DataView()

Source:

DataView.cs

Initializes a new instance of the DataView class.

public:
 DataView();

public DataView ();

Public Sub New ()

Examples

The following example creates a new DataView.

private void MakeDataView()
{
    DataView view = new DataView();

    view.Table = DataSet1.Tables["Suppliers"];
    view.AllowDelete = true;
    view.AllowEdit = true;
    view.AllowNew = true;
    view.RowFilter = "City = 'Berlin'";
    view.RowStateFilter = DataViewRowState.ModifiedCurrent;
    view.Sort = "CompanyName DESC";

    // Simple-bind to a TextBox control
    Text1.DataBindings.Add("Text", view, "CompanyName");
}

Private Sub MakeDataView()
    Dim view As New DataView()

    view.Table = DataSet1.Tables("Suppliers")
    view.AllowDelete = True
    view.AllowEdit = True
    view.AllowNew = True
    view.RowFilter = "City = 'Berlin'"
    view.RowStateFilter = DataViewRowState.ModifiedCurrent
    view.Sort = "CompanyName DESC"
    
    ' Simple-bind to a TextBox control
    Text1.DataBindings.Add("Text", view, "CompanyName")
End Sub

See also

• DataTable
• DataViewManager
• DataSets, DataTables, and DataViews (ADO.NET)

DataView(DataTable)

Source:

DataView.cs

Initializes a new instance of the DataView class with the specified DataTable.

public:
 DataView(System::Data::DataTable ^ table);

public DataView (System.Data.DataTable? table);

new System.Data.DataView : System.Data.DataTable -> System.Data.DataView

Public Sub New (table As DataTable)

Parameters

table

DataTable

A DataTable to add to the DataView.

Examples

The following example creates a new DataView with the specified DataTable.

private void MakeDataView()
{
    DataView view = new DataView(DataSet1.Tables["Suppliers"]);

    // Bind a ComboBox control to the DataView.
    Combo1.DataSource = view;
    Combo1.DisplayMember = "Suppliers.CompanyName";
}

Private Sub MakeDataView()
    Dim view As DataView
    view = New DataView(DataSet1.Tables("Suppliers"))

    ' Bind a ComboBox control to the DataView.
    Combo1.DataSource = view
    Combo1.DisplayMember = "Suppliers.CompanyName"
End Sub

See also

• DataSets, DataTables, and DataViews (ADO.NET)

DataView(DataTable, String, String, DataViewRowState)

Source:

DataView.cs

Initializes a new instance of the DataView class with the specified DataTable, RowFilter, Sort, and DataViewRowState.

public:
 DataView(System::Data::DataTable ^ table, System::String ^ RowFilter, System::String ^ Sort, System::Data::DataViewRowState RowState);

public DataView (System.Data.DataTable table, string? RowFilter, string? Sort, System.Data.DataViewRowState RowState);

new System.Data.DataView : System.Data.DataTable * string * string * System.Data.DataViewRowState -> System.Data.DataView

Public Sub New (table As DataTable, RowFilter As String, Sort As String, RowState As DataViewRowState)

Parameters

table

DataTable

A DataTable to add to the DataView.

RowFilter

String

A RowFilter to apply to the DataView.

Sort

String

A Sort to apply to the DataView.

RowState

DataViewRowState

A DataViewRowState to apply to the DataView.

Examples

The following example creates a new DataView with the specified DataTable.

private void MakeDataView(DataSet dataSet)
{
    DataView view = new DataView(dataSet.Tables["Suppliers"],
        "Country = 'UK'", "CompanyName",
        DataViewRowState.CurrentRows);
    view.AllowEdit = true;
    view.AllowNew = true;
    view.AllowDelete = true;
}

Private Sub MakeDataView(ByVal dataSet As DataSet)
    Dim view As New DataView(dataSet.Tables("Suppliers"), _
        "Country = 'UK'", "CompanyName", _
        DataViewRowState.CurrentRows)
    view.AllowEdit = True
    view.AllowNew = True
    view.AllowDelete = True
End Sub

See also

• DataSets, DataTables, and DataViews (ADO.NET)