DataView DataView DataView DataView Constructors

Definition

Overloads

DataView() DataView() DataView()

Initializes a new instance of the DataView class.

DataView(DataTable) DataView(DataTable) DataView(DataTable) DataView(DataTable)

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

DataView(DataTable, String, String, DataViewRowState) DataView(DataTable, String, String, DataViewRowState) DataView(DataTable, String, String, DataViewRowState) DataView(DataTable, String, String, DataViewRowState)

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

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

DataView(DataTable) DataView(DataTable) DataView(DataTable) 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);
new System.Data.DataView : System.Data.DataTable -> System.Data.DataView
Public Sub New (table As DataTable)

Parameters

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

DataView(DataTable, String, String, DataViewRowState) DataView(DataTable, String, String, DataViewRowState) DataView(DataTable, String, String, DataViewRowState) 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);
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

RowFilter
String String String String

A RowFilter to apply to the DataView.

Sort
String String String String

A Sort 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