Select distinct rows in c# datatable on single column but return all columns

Question

DataView view = new DataView(dt);
dt= view.ToTable(true, "id");

If i have 2 columns "id" and "name" i need to get the distinct "id" but not the distinct "name" but i need to keep the column "name" in my datatable what shall i do?

Zaheer Ul Hassan · Answer 1 · 2017-04-25T03:51:23.070

3

DataView view = new DataView(table);
DataTable distinctValues = view.ToTable(true, "Column1", "Column2" ...);

If i have 2 columns "id" and "name" i need to get the distinct "id" but not the distinct "name" but i need to keep the column "name" in my datatable what shall i do?

OK, then i need grouping, not distinct.I could do it with Linq to DataSet: table.AsEnumerable().GroupBy(row => row.Field<int>("id")).Select(group =>group.First()).CopyToDataTable()

edited Apr 25 '17 at 03:51

answered Apr 25 '17 at 03:44

Zaheer Ul Hassan

771
9
24

but its returning only one row :( – Himanshu Suthar Apr 25 '17 at 04:31
@HimanshuSuthar which one? and which way you are using distinct or grouping? – Zaheer Ul Hassan Apr 25 '17 at 04:32
there should 3 distinct rows after group by operations, but it returns only first. – Himanshu Suthar Apr 25 '17 at 04:36
Check this link [here](http://stackoverflow.com/questions/20582391/linq-distinct-or-group-by-multiple-properties). – Zaheer Ul Hassan Apr 25 '17 at 04:44

Select distinct rows in c# datatable on single column but return all columns

1 Answers1