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
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.