Sorting rows in datatable

Question

I have a datatable where I would like to move all the rows that have a certain firstname and lastname to the top of the table.

public DataTable SortByFirstNameAndLastNameMatch(DataTable table, string firstName, string lastName)
    {
        DataTable ret = new DataTable();
        foreach (DataRow dataRow in table.Rows)
        {
            if (dataRow["NomArtiste"].ToString().ToLower() == lastName.ToLower() && dataRow["PrenomArtiste"].ToString().ToLower() == firstName.ToLower())
            {
                ret.ImportRow(dataRow);
            }
        }

        ret.Merge(table);
        return RemoveDuplicateRows(ret, "AlbumID");
    }

Is there a way I can do this using a linq expression or a comparer without making a new datatable?

Are you trying to modify the order in the database? Or just get and ordered result? — crashmstr
– crashmstr, Commented Nov 5, 2013 at 19:41
Well, I guess see DataViews/DefaultView - that may work for you. (You must use the DataView and not the natural ordering, however!) — user2864740
– user2864740, Commented Nov 5, 2013 at 19:45
If you use .AsEnumerable() (msdn.microsoft.com/en-us/library/…) on the DataTable then you can apply all the LINQ sorting/filtering/transforming/etc. that you want on it. — David
– David, Commented Nov 5, 2013 at 19:47

Tarik · Accepted Answer · 2013-11-06 06:12:15Z

3

You can create a new DataView on your DataTable and apply whatever sorting and filtering you see fit. See http://msdn.microsoft.com/en-us/library/system.data.dataview.sort.aspx for an example.

Alternatively you can do it with LINQ:

var sortedTableQuery = table.OrderBy(r => r["NomArtiste"].ToString() == lastName ? 0 : 1).ThenBy(r => r["PrenomArtiste"].ToString() == firstName ? 0 : 1).ThenBy(r => r["NomArtiste"].ToString()).ThenBy(r => r["PrenomArtiste"].ToString());
var a = sortedTableQuery.ToArray();

edited Nov 6, 2013 at 6:12

answered Nov 5, 2013 at 19:45

Tarik

11.2k2 gold badges31 silver badges47 bronze badges

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

Comments

tclark333 · Accepted Answer · 2013-11-05 19:51:00Z

2

In Linq, it would look something like this:

var sortedNames = unsortedNames.OrderBy(n => n == lastName ? 1 : 2).ThenBy(n => n == firstName ? 1 : 2));

answered Nov 5, 2013 at 19:51

tclark333

5675 silver badges13 bronze badges

Comments

bilal_izloo · Accepted Answer · 2013-11-06 06:20:28Z

0

DataView dv=datatable.DefaultView;
dv.Sort = "ColumnName Asc ,ColumnName Asc, ColumnName Asc , ColumnName Asc";
datatable=dv.toTable().Copy();

answered Nov 6, 2013 at 6:20

bilal_izloo

371 gold badge1 silver badge10 bronze badges

Collectives™ on Stack Overflow

Sorting rows in datatable

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related