Sorting DataTable object by current values, while preserving original values

Question

In C# I have a DataTable that has been modified several times, where some rows are deleted, some rows are updated, some rows remain the same.

DataTable detailsTable = GetDdetails();

Insert code that does the following:

Sorts my DataTable according to specific column (myColumn ASC) based on current values in the rows (current values accessible through detailsTable.Rows[i]["ColumnName", DataRowVersion.Original])
Preserves original data in the rows, because both, original and current values are used later in UseDetails function (values accessible through detailsTable.Rows[i]["ColumnName", DataRowVersion.Current])

Code:

UseDetails(detailsTable);

I encountered a few problems:

Traditional way to sort values creates view from the detailsTable, which will not bring deleted rows in.
Specifically including deleted fields (using filters) will remove their deleted status.
Copying data from an unsorted table to sorted will throw an exception if attempting to access deleted field

Thank you in advance

pasx · Accepted Answer · 2025-04-08 18:06:19Z

0

You could keep a copy of the original dataset.

To make it easier you can create your own version of DataTable e.g.:

internal class DataTableWithOriginalData : DataTable
{
    public DataTableWithOriginalData(DataTable table) : base ()
    {
        OriginalData = table.Copy();        
    }

    public DataTable OriginalData { get; }
}

answered Apr 8 at 18:06

pasx

3,0131 gold badge38 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

concentriq Apr 9 at 20:03

thank you, but that's not what i was looking for: DataTable has data versioning feature, where within the same object/same row contains original, current, and scheduled values, as well as current state of the data row (modified, deleted, etc..). Im looking for a way to re-sort the data table based on its current values, while preserving historical data and current state for each Data row.

Collectives™ on Stack Overflow

Sorting DataTable object by current values, while preserving original values

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related