Efficiently Remove Duplicates in Dataset

This blog discusses the efficient way to remove duplicates in datasets.

Remember, the pain of removing duplicates in fetched dataset by looping, comparing etc.

it can be handled easily by using DataView.ToTable Method. The syntax is below.

DataView.ToTable(bool distinct, string[] columnNames)

distinct: If it's true, the returned DataTable contains rows that have distinct values for all its columns specified in the second parameter. Default value is false.

columnNames: A string array that contains a list of the column names to be included in the returned table. The order of columns in returned table would be same as it’s appear in the array.

Ex1

DataTable temp = dt.DefaultView.ToTable(true, "Region");

Ex2

DataTable temp = dt.DefaultView.ToTable(true, "Region", "City");

Reference:

DataView.ToTable Method