Want to Remove Duplicate Value rows of banks category, Want to remove second time comming axis,bob,hdfc,indian bank and state bank

Karthi

Hi @Gopikrishna_S ,

use below code

dt.AsEnumerable().GroupBy(Function(i) i.Field(Of String)("BANK")).Select(Function(g) g.First).CopyToDataTable()
Or
((From LineNo In dt.DefaultView.ToTable(True,"BANK").Select().ToList() Select (From row In dt.Select Where row("BANK").ToString=LineNo("BANK").ToString Select row).ToList(0)).ToList()).CopyToDatatable()

Regards,
Arivu

Hello @Gopikrishna_S

Can you plz check the below video.

Thanks

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.