How to get using linq only specific values from datatable

[Andrei_Croitoru]

Hello!

I have this datatable.
How can i use linq/lambda expression to get the values from DRAW_Cnt column, only for abc and save them in a list.
For exmaple for abc i have List = {“0”,“1”}

[arivu96 (Arivazhagan A)]

Hi @Andrei_Croitoru ,
Use below query
dt.select("Code= 'abc'").CopyToDataTable()
OR
(From p in dt.Select() where p("Code").Equals("abc") select p).ToArray.CopyToDataTable()

Regards,
Arivu

[ppr (Peter Preuss)]

Give a try in

vals =

(From d in yourDatatableVar.asenumerable
Where d(yourcolnameorindex).tostring.trim.toupper.equals(“ABC”)
Select v=d(yourcolnameorindex).tostring.trim).distinct().tolist

[Andrei_Croitoru]

This is not my question

[kadiravan_kalidoss (Kadiravan K)]

Hi @Andrei_Croitoru,

DataTableGroupByToList.xaml (7.0 KB)

listVariable = (from x in dtInput.AsEnumerable.Where(function(x) x(“Code”).ToString.Trim.Equals(“abc”))Select Convert.ToString(x(“DRAW_Cnt”))).ToList

Thanks!