We can remove duplicate entries by using ".Distinct()" in arraylist
Example:
======
I have createdby column exist in testtable which have more one row exist with 5 duplicate entries. i have to get only one row
ID Createdby
=== ========
1 Reddy
2 Reddy
3 Reddy
4 Reddy
In above thing i need to select only one "Reddy"
DataTable table=new DataTable("MyTable");//Actually i am getting this table data from database
DataColumn col=new DataColumn("Createdby");
var childrows = table.AsEnumerable().Select( row => row.Field<object>(col)).Distinct().ToArray();
Example:
======
I have createdby column exist in testtable which have more one row exist with 5 duplicate entries. i have to get only one row
ID Createdby
=== ========
1 Reddy
2 Reddy
3 Reddy
4 Reddy
In above thing i need to select only one "Reddy"
DataTable table=new DataTable("MyTable");//Actually i am getting this table data from database
DataColumn col=new DataColumn("Createdby");
var childrows = table.AsEnumerable().Select( row => row.Field<object>(col)).Distinct().ToArray();
No comments:
Post a Comment