Like wise many numbers are there dynamically
i need output should be 100,123,124,125,126 and 110,120,129,130 and etc…
How can i do this. i am just using for each row inside for each row with input datatable and i am finding the duplicates then printing but it looks like this i need the last line of the duplicates.
hope this expression would help you resolve this yourdatatablename = yourdatatablename.AsEnumerable().Groupby(Function(a) a.Field(Of String)(“yourcolumnname”).ToString).Select(Function(b) b.Last()).CopyToDatatable()
edit: not sure this will work because i doubt whether duplicates with extra value around will also be considered in group by…lets try
Cheers @Sriram07