Getting unique rows from Datatable.

We use Distinct keyword to get only unique rows.

For Example:-

var unique_rows = dt_requisition.AsEnumerable().Distinct(DataRowComparer.Default);
DataTable dt_new_requisition = unique_rows.CopyToDataTable();

Here,dt_requisition is my DataTable object.