Remove Duplicate Rows From DataTable in c#

Karthi Keyan

Hi,

I have DataTable. That have 2 Columns. one is Element, another one is Attribute. Element Column have duplicate. but Attribute not. i want to remove Entire row if is there any duplicate in Element Column. like Follow.

Element	Attribute
component/header	@[version = '1.2']
component/header/title[cited = 'no']	@[type = 'series']
component/header/title[cited = 'no']	@[level = 'Product']

from this table i want remove 4th row. i tried to check while adding each row by DataTable.Select. but it return an error. because the Element having single quotes. Also i tried

dt.AsEnumerable().Distinct(DataRowComparer.Default); but that's not help full. is there any idea about this.

Thanks in advance.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta9y ago
Accepted answer
Hey

You can use simply distinct to get the value from datatable
DataTable distinctTable = dtEmp.DefaultView.ToTable(true, "ElementName");
Good luck !!
Karthi Keyan9y ago
@Amit,

By using the Code dt1 = dt.DefaultView.ToTable(true, "Elements");

I am getting only Elements Column. I want both Elements and Attributes columns. If any Duplicates occures in Elements column That Entire Row Must Be Removed. while adding to the dt1 i want to add both columns without duplicates in Elements Column.

I tried dt1 = dt.DefaultView.ToTable(true, "Elements","Attribute");

But That's Not Working. What I want do Now.
Karthi Keyan9y ago
@Amit,

Thank you Amit.
Amit Gupta9y ago
By default, the default sorting was asc, so it will take the first one.
Karthi Keyan9y ago
@Amit,

It working Amit. Thanks Again. and i want to know one thing, It will take 1st row or last row???...
Manas Mohapatra9y ago
Follow below links that may help you:

https://stackoverflow.com/questions/4415519/best-way-to-remove-duplicate-entries-from-a-data-table

http://dotnetguts.blogspot.com/2007/02/removing-duplicate-records-from.html

http://www.dotnetspider.com/resources/4535-Remove-duplicate-records-from-table.aspx