How to get distinct values from data table?

Question

I am trying to return an `array with distinct records. But this piece of code isn’t working. What am I doing wrong?

return table.AsEnumerable().Distinct(DataRowComparer.Default).ToArray();

what you are doing is giving you distinct rows. Is there an element in the row you want to be distinct? What is it you want to do. — Hogan, Apr 16 '19 at 21:34
It depends on which fields/columns from your table you wants a distinct data. Reference taken from similar questions on stack overflow. https://stackoverflow.com/questions/3242892/select-distinct-rows-from-datatable-in-linq — Lokesh Khinchi, Apr 17 '19 at 04:41

score 0 · Answer 1 · edited Apr 17 '19 at 00:01

0

table
    .AsEnumerable()
    .GroupBy(row => row.Field<DataType>("FieldName"))
    .Select(group => group.First())
    .ToArray()

edited Apr 17 '19 at 00:01

Wai Ha Lee

answered Apr 16 '19 at 21:54

Suresh Kaushik

I assumed OP wants to get distinct by one field, since the question was ambiguous, lot of assumptions. – Suresh Kaushik Apr 16 '19 at 22:17
1

That's not what I meant. I meant that it this would be a better answer if instead of just a line of code, you provided some explaination as to why this code answers the question. – pppery Apr 16 '19 at 22:18
Alright, I am sorry, I suppose it is straight forward, if OP wants to get distinct by one field, then group by that field, and get distinct groups. – Suresh Kaushik Apr 16 '19 at 22:19

1 Answers1