Articles → ADO.NET → Get Distinct Rows From Datatable C#

Get Distinct Rows From Datatable C#

In this article, I will explain how to get distinct rows in the data table.

Create Data Table

First of all create an object of DataTable class and add data in it (See the following code)

DataTable table = new DataTable();
table.Columns.Add("Name", typeof(System.String));
table.Columns.Add("Gender", typeof(System.String));
table.Columns.Add("City", typeof(System.String));

DataRow row = table.NewRow();
row["Name"] = "Person 1";
row["Gender"] = "Male";
row["City"] = "Delhi";
table.Rows.Add(row);

row = table.NewRow();
row["Name"] = "Person 1";
row["Gender"] = "Male";
row["City"] = "Delhi";
table.Rows.Add(row);

row = table.NewRow();
row["Name"] = "Person 2";
row["Gender"] = "Female";
row["City"] = "Mumbai";
table.Rows.Add(row);

Once you execute preceding code, you see the following records

Picture showing the datatable with the duplicate records

Click to Enlarge

Find Distinct Records

ToTable method is used to get the distinct records. The first parameter of ToTable specifies if the record is distinct or not So the following code will be added to get distinct record

DataTable distinct = table.DefaultView.ToTable(true, "Name", "Gender", "City");

So the output is

Picture showing the datatable with the distinct records

Click to Enlarge

Posted By -	Karan Gupta

Posted On -	Monday, December 21, 2015

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**