Category: ASP.NET

29 Jun 2017 06:00

Joined:	06/06/2011
Level:	Gold
Points:	1173

Points:	3

Linq query to find unique and duplicate rows and assign values

From a datatable I want to find duplicate rows for a particular column and for this rows I need to increment value as 1,2,3, etc . For other rows value should be 1. How to do in linq csharp..

Col1 col2
And 1
See 1
Things 1
She 1
And 2
Hi 2
Vil 2

#769280

12 Jul 2017 18:17

Joined:	23/02/2011
Level:	Bronze
Points:	84

Points:	4

GroupBy your datatable then Iterate each group and update your version value[like. 1,2,3] . If require add orderby using primary key

Find the below code for your ref:

SampleClass structure
-------------------
class SampleClass
{
public int UniqueId { get; set; }

public string DataColumn { get; set; }

public int Version { get; set; }
}

Main Method
------------------
List<SampleClass> columnValues = new List<SampleClass>();// Load you data table here

int cnt;
var sList = columnValues.GroupBy(s => s.DataColumn).ToList().Select(group =>
{
cnt = 0;
return group.ToList().Select(i =>
{
i.Version = ++cnt;
return i;
}).ToList();
}).ToList().SelectMany(s => s).ToList<SampleClass>(); // Add orderby(uniqueId) here if required

#769284

17 Jul 2017 01:31

Joined:	06/06/2011
Level:	Gold
Points:	1173

Points:	1

I find it complex.. please share some easy code

Linq query to find unique and duplicate rows and assign values

About dotnetspider.com

Quick Links

General

Services