DataView Constructors

Reference

Definition

Namespace:: System.Data

Assemblies:: netstandard.dll, System.Data.Common.dll

Assembly:: System.Data.Common.dll

Assembly:: System.Data.dll

Assembly:: netstandard.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

Source:: DataView.cs

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

Applies to

.NET 10 and other versions

Product	Versions
.NET	Core 2.0, Core 2.1, Core 2.2, Core 3.0, Core 3.1, 5, 6, 7, 8, 9, 10
.NET Framework	1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1
.NET Standard	2.0, 2.1

DataView(DataTable)

Source:: DataView.cs

Source:: DataView.cs

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

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

Applies to

.NET 10 and other versions

Product	Versions
.NET	Core 2.0, Core 2.1, Core 2.2, Core 3.0, Core 3.1, 5, 6, 7, 8, 9, 10
.NET Framework	1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1
.NET Standard	2.0, 2.1

DataView(DataTable, String, String, DataViewRowState)

Source:: DataView.cs

Source:: DataView.cs

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

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

Applies to

.NET 10 and other versions

Product	Versions
.NET	Core 2.0, Core 2.1, Core 2.2, Core 3.0, Core 3.1, 5, 6, 7, 8, 9, 10
.NET Framework	1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1
.NET Standard	2.0, 2.1

Share via

DataView Constructors

Definition

Overloads

DataView()

Examples

See also

Applies to

DataView(DataTable)

Parameters

Examples

See also

Applies to

DataView(DataTable, String, String, DataViewRowState)

Parameters

Examples

See also

Applies to

Additional resources