Hi All,
Please help me to solve this
Since dealing with datatable with large data, I tried in LinQ Query instead of For Each loop:
What I have in a Datatable:
ColumnA ColumnB
A
B
A
X
C
X
A
Y
What I need:
ColumnA ColumnB
A 1
B 2
A 3
X
C 4
X
A 5
Y
LinQ Query:
What I Tried:
After cloning the Datatable “DestDT” from “SourceDT”,
Assign:
TRN = 0
Assign:
DestDT = (From a In SourceDT.AsEnumerable() Select DestDT.LoadDataRow (New Object() {
a.Field(Of Object)(“ColumnA”), If( (a.Field(Of String)(“ColumnA”)=“A” Or a.Field(Of String)(“ColumnA”)=“B” Or a.Field(Of String)(“ColumnA”)=“C”),TRN+1.ToString,“”)
},False)).CopyToDataTable
What I am getting is 1 for all the matching rows. Please help