DataView Constructors

Definition

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()

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

Applies to

DataView(DataTable)

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

public:
 DataView(System::Data::DataTable ^ table);
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

Applies to

DataView(DataTable, String, String, DataViewRowState)

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);
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

Applies to