How Can I Sort a DataTable's Rows Without Modifying the Original Table?

Data table row sorting method

When working with data tables, you often need to sort rows based on specific conditions. Suppose there is a data table with two columns:

<code>COL1   COL2
Abc    5
Def    8
Ghi    3</code>

The goal is to sort this data table in descending order based on the value of the COL2 column, resulting in the following output:

<code>COL1   COL2
Def    8
Abc    5
Ghi    3</code>

While sorting a DataView is simple, problems arise if you want to sort the DataTable itself directly, without using a DataView.

Solution

Direct in-place sorting of a DataTable is not possible. However, you can create a new DataTable created from the sorted DataView if desired. Here’s how:

<code class="language-csharp">DataView dv = ft.DefaultView;
dv.Sort = "COL2 desc";
DataTable sortedDT = dv.ToTable();</code>

In the code, first create a DataView (dv) from the original DataTable (ft). Then, use the Sort property to apply sorting conditions to the DataView. Finally, use the ToTable() method to create a new DataTable (sortedDT) from the sorted DataView.

With this approach, the desired sorting can be achieved without modifying the original DataTable.

The above is the detailed content of How Can I Sort a DataTable's Rows Without Modifying the Original Table?. For more information, please follow other related articles on the PHP Chinese website!