DataView::ToTable Method (String^, Boolean, array<String^>^)
Assembly: System.Data (in System.Data.dll)
public: DataTable^ ToTable( String^ tableName, bool distinct, ... array<String^>^ columnNames )
If true, the returned DataTable contains rows that have distinct values for all its columns. The default value is false.
The following console application example creates a DataTable, fills the DataTable with data, sorts the DataView, and finally creates a DataTablewith a new name that contains just two columns, limited to rows in which all values are unique.
The example displays the following output in the console window:
Original table name: NewTable Current Values in Table 1, Fruit, Apple, 14 2, Fruit, Orange, 27 3, Bread, Muffin, 23 4, Fish, Salmon, 12 5, Fish, Salmon, 15 6, Bread, Croissant, 23 Current Values in View 3, Bread, Muffin, 23 6, Bread, Croissant, 23 4, Fish, Salmon, 12 5, Fish, Salmon, 15 1, Fruit, Apple, 14 2, Fruit, Orange, 27 Table created from sorted DataView Bread, 23 Fish, 12 Fish, 15 Fruit, 14 Fruit, 27 New table name: UniqueData
Available since 2.0