I want get distinct rows on the basis of two columns

[Manish540 (Manish Shettigar)]

This link may help you,

Distinct values in a datatable

I will go with @akhi_s27’s solution but other way around. first do a Datatable select copyDataTable = dt.Select("Date= MAX(Date)").CopyToDataTable(); then get distinct values copyDataTable .DefaultView.ToTable(True,"ColumnName")

AND,

Distinct rows from data table

The query is correct only but make it Orderby is Order by. i missed the space ((From LineNo In dt.DefaultView.ToTable(True,"ID").Select().ToList() Select (From row In dt.Select Order by row("AGE") descending Where row("ID").ToString=LineNo("ID").ToString Select row).ToList(0)).ToList()).CopyToDatatable() Flowchart.xaml (13.0 KB) Regards, Arivu